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;
}
}
