ritacse
12/6/2017 - 11:24 AM

XMLDate for save


 var xmlKpiChild = new XElement("ArrayOfEmp_Appraisal_Info", listEmpAppraisalInfo.Select(x => new XElement("Emp_Appraisal_Info",

                new XElement("Id", x.Id),
                new XElement("EmpRevisedRating", x.EmpRevisedRating),
                new XElement("EmpRevisedNote", x.EmpRevisedNote)

            )));
            string sXML = xmlKpiChild.ToString();
            var item = ExecuteStoredProcedure("Update_Emp_Appraisal_Info_Employee_Revised_Rating_SP'" + sXML + "'");
            
            
            
            //-------------- Another ---------------
            
            ResultSaveVM o_VM_SP_Results = new ResultSaveVM();

            string DataXml = RejectedRollList.Any() ? XMLUtility.XmlSerialize(RejectedRollList) : "No_Data";
            o_VM_SP_Results = ExecWithStoreProcedure<ResultSaveVM>("Textile_QC_SendRejectedRolls_Insert_Update_SP   '" + DataXml + "' ").FirstOrDefault();

            return o_VM_SP_Results;