public int?Save(tblAllocConsultDoctor tblins, List <EntityAllocaConDocDetails> lst)
{
int?SrNo = 0;
try
{
objData.STP_Insert_tblAllocaConsultDoc(Convert.ToInt32(tblins.CategoryId), Convert.ToInt32(tblins.ConsultDocId), Convert.ToDecimal(tblins.ConsultCharges), Convert.ToDateTime(tblins.Consult_Date), ref SrNo);
foreach (EntityAllocaConDocDetails item in lst)
{
tblAllocConsultDoctorDetail tbl = new tblAllocConsultDoctorDetail()
{
AdmitId = Convert.ToInt32(item.AdmitId),
CategoryId = Convert.ToInt32(tblins.CategoryId),
ConsultDocId = Convert.ToInt32(tblins.ConsultDocId),
Consult_Date = Convert.ToDateTime(tblins.Consult_Date),
ConsultCharges = Convert.ToDecimal(tblins.ConsultCharges),
SrNo = Convert.ToInt32(SrNo),
IsDelete = false
};
objData.tblAllocConsultDoctorDetails.InsertOnSubmit(tbl);
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
return(SrNo);
}
public void Update(List <EntityAllocaConDocDetails> lst)
{
try
{
foreach (EntityAllocaConDocDetails item in lst)
{
tblAllocConsultDoctorDetail objsal = new tblAllocConsultDoctorDetail();
objsal = (from tbl in objData.tblAllocConsultDoctorDetails
where tbl.SrDetailId == item.SrDetailId &&
tbl.IsDelete == false
select tbl).FirstOrDefault();
if (objsal != null)
{
objsal.AdmitId = item.AdmitId;
objsal.IsDelete = item.IsDelete;
}
else
{
objsal = new tblAllocConsultDoctorDetail()
{
AdmitId = Convert.ToInt32(item.AdmitId), SrNo = Convert.ToInt32(item.SrNo)
};
objData.tblAllocConsultDoctorDetails.InsertOnSubmit(objsal);
}
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public void Update(tblAllocConsultDoctor obj, List <EntityAllocaConDocDetails> lst)
{
try
{
tblAllocConsultDoctor objcurrent = (from tbl in objData.tblAllocConsultDoctors
where tbl.SrNo == obj.SrNo
select tbl).FirstOrDefault();
if (objcurrent != null)
{
objcurrent.CategoryId = obj.CategoryId;
objcurrent.ConsultDocId = obj.ConsultDocId;
objcurrent.Consult_Date = obj.Consult_Date;
objcurrent.ConsultCharges = obj.ConsultCharges;
}
foreach (EntityAllocaConDocDetails item in lst)
{
tblAllocConsultDoctorDetail objsal = new tblAllocConsultDoctorDetail();
objsal = (from tbl in objData.tblAllocConsultDoctorDetails
where tbl.SrDetailId == item.SrDetailId &&
tbl.SrNo == item.SrNo && tbl.AdmitId == item.AdmitId &&
tbl.IsDelete == false
select tbl).FirstOrDefault();
if (objsal != null)
{
objsal.AdmitId = Convert.ToInt32(item.AdmitId);
objsal.CategoryId = obj.CategoryId;
objsal.ConsultDocId = obj.ConsultDocId;
objsal.Consult_Date = obj.Consult_Date;
objsal.ConsultCharges = obj.ConsultCharges;
objsal.IsDelete = item.IsDelete;
}
else
{
objsal = new tblAllocConsultDoctorDetail()
{
AdmitId = item.AdmitId,
CategoryId = obj.CategoryId,
ConsultDocId = obj.ConsultDocId,
Consult_Date = obj.Consult_Date,
ConsultCharges = obj.ConsultCharges,
SrNo = Convert.ToInt32(obj.SrNo),
IsDelete = false
};
objData.tblAllocConsultDoctorDetails.InsertOnSubmit(objsal);
}
}
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
