public int SaveHospitalInfo(HospitalInfo hospitalinfo) { try { List<HospitalInfo> hospital = new List<HospitalInfo>(); return new HospitalInfoDAL().Save(hospitalinfo, DBNull.Value); } catch (Exception ex) { objHelper.WriteErrorLog("HCP.WebAPI --> HospitalInfoController--> SaveHospitalInfo-->" + ex.Message); //throw ex; } return 0; }
public int Save(HospitalInfo hospitalinfo, DBNull t2) { var result = 0; var dbCtx = new AdvocateHealthCareEntities(); var dtHospitalInfoType = new DataTable(); dtHospitalInfoType.Columns.Add("HospitalID", typeof(int)); dtHospitalInfoType.Columns.Add("HospitalName", typeof(string)); dtHospitalInfoType.Columns.Add("Description", typeof(string)); dtHospitalInfoType.Columns.Add("CreatedDate", typeof(DateTime)); dtHospitalInfoType.Columns.Add("CreatedBy", typeof(string)); dtHospitalInfoType.Columns.Add("ModifiedDate", typeof(DateTime)); dtHospitalInfoType.Columns.Add("ModifiedBy", typeof(string)); //dtHospitalInfoType.Rows.Add(hospitalinfo.HospitalID, hospitalinfo.HospitalName, hospitalinfo.Description, // hospitalinfo.CreatedDate, hospitalinfo.CreatedBy, hospitalinfo.ModifiedDate, // hospitalinfo.ModifiedBy); dtHospitalInfoType.Rows.Add(7, "dsggcxcf", "dsggfsf", null, null, null, null); var spSaveHospitalInfo = new SqlParameter(); spSaveHospitalInfo.ParameterName = "@HospitalType"; spSaveHospitalInfo.Value = dtHospitalInfoType; spSaveHospitalInfo.SqlDbType = SqlDbType.Structured; spSaveHospitalInfo.TypeName = "HospitalType"; var caseId = new SqlParameter("@LoggedInUser", SqlDbType.VarChar); //caseId.Value = hospitalinfo.LoggedInUser; caseId.Value = "PTG"; result = dbCtx.Database.ExecuteSqlCommand("EXEC " + DataAccess.DataAccessConstants.SaveHospitalInfo + "@HospitalType, @LoggedInUser", new object[] { spSaveHospitalInfo, caseId }); if (result == 0) { return 0; } else { return 1; } }