public int?Save(tblNursingManagement tblins, List <EntityNursingManagementDetails> lst)
{
int?SrNo = 0;
try
{
objData.STP_Insert_tblNursingManagement(Convert.ToInt32(tblins.CategoryId), Convert.ToInt32(tblins.NurseId), Convert.ToString(tblins.Department), Convert.ToDateTime(tblins.TreatmentDate), ref SrNo);
foreach (EntityNursingManagementDetails item in lst)
{
tblNursingManagementDetail tbl = new tblNursingManagementDetail()
{
PatientId = Convert.ToInt32(item.PatientId),
InjectableMedications = Convert.ToString(item.InjectableMedications),
Infusions = Convert.ToString(item.Infusions),
Oral = Convert.ToString(item.Oral),
NursingCare = Convert.ToString(item.NursingCare),
TreatmentTime = Convert.ToString(item.TreatmentTime),
CategoryId = Convert.ToInt32(tblins.CategoryId),
NurseId = Convert.ToInt32(tblins.NurseId),
TreatmentDate = Convert.ToDateTime(tblins.TreatmentDate),
Department = Convert.ToString(tblins.Department),
SrNo = Convert.ToInt32(SrNo),
IsDelete = false
};
objData.tblNursingManagementDetails.InsertOnSubmit(tbl);
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
return(SrNo);
}
public void Update(tblNursingManagement obj, List <EntityNursingManagementDetails> lst)
{
try
{
tblNursingManagement objcurrent = (from tbl in objData.tblNursingManagements
where tbl.SrNo == obj.SrNo
select tbl).FirstOrDefault();
if (objcurrent != null)
{
objcurrent.CategoryId = obj.CategoryId;
objcurrent.NurseId = obj.NurseId;
objcurrent.TreatmentDate = obj.TreatmentDate;
objcurrent.Department = obj.Department;
}
foreach (EntityNursingManagementDetails item in lst)
{
tblNursingManagementDetail objsal = new tblNursingManagementDetail();
objsal = (from tbl in objData.tblNursingManagementDetails
where tbl.SrDetailId == item.SrDetailId &&
tbl.SrNo == item.SrNo && tbl.PatientId == item.PatientId &&
tbl.IsDelete == false
select tbl).FirstOrDefault();
if (objsal != null)
{
objsal.PatientId = Convert.ToInt32(item.PatientId);
objsal.CategoryId = obj.CategoryId;
objsal.NurseId = obj.NurseId;
objsal.TreatmentDate = obj.TreatmentDate;
objsal.InjectableMedications = item.InjectableMedications;
objsal.Infusions = item.Infusions;
objsal.Oral = item.Oral;
objsal.NursingCare = item.NursingCare;
objsal.TreatmentTime = item.TreatmentTime;
objsal.Department = obj.Department;
objsal.IsDelete = item.IsDelete;
}
else
{
objsal = new tblNursingManagementDetail()
{
PatientId = item.PatientId,
CategoryId = obj.CategoryId,
NurseId = obj.NurseId,
TreatmentDate = obj.TreatmentDate,
Department = obj.Department,
InjectableMedications = item.InjectableMedications,
Infusions = item.Infusions,
Oral = item.Oral,
NursingCare = item.NursingCare,
TreatmentTime = item.TreatmentTime,
SrNo = Convert.ToInt32(obj.SrNo),
IsDelete = false
};
objData.tblNursingManagementDetails.InsertOnSubmit(objsal);
}
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
