public bool Insert(DataTable dT, tblCommmissionMastHead objtblCommmissionMastHead)
{
Int64 value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblCommmissionMastHead objHead = new tblCommmissionMastHead();
db.tblCommmissionMastHeads.AddObject(objtblCommmissionMastHead);
db.SaveChanges();
value = objtblCommmissionMastHead.Head_Idno;
if (dT != null && dT.Rows.Count > 0)
{
for (int i = 0; i < dT.Rows.Count; i++)
{
if (Convert.ToDouble(dT.Rows[i]["Comision_Amnt"]) > 0)
{
tblCommmissionMastDetl obj = new tblCommmissionMastDetl();
obj.Head_Idno = value;
obj.Tocity_Idno = string.IsNullOrEmpty(Convert.ToString(dT.Rows[i]["Tocity_Idno"])) ? 0 : Convert.ToInt32(dT.Rows[i]["Tocity_Idno"]);
obj.Comsn_Amnt = string.IsNullOrEmpty(Convert.ToString(dT.Rows[i]["Comision_Amnt"])) ? 0 : Convert.ToDouble(dT.Rows[i]["Comision_Amnt"]);
db.tblCommmissionMastDetls.AddObject(obj);
db.SaveChanges();
}
}
}
return(true);
}
}
public Int64 Delete(int intItemIdno, Int32 FromCityIdno, Int32 StateIdno, DateTime Date)
{
Int64 intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblCommmissionMastHead objMast = (from mast in db.tblCommmissionMastHeads
where mast.Item_Idno == intItemIdno && mast.FromCity_Idno == FromCityIdno && mast.State_Idno == StateIdno && mast.Date == Date
select mast).FirstOrDefault();
if (objMast != null)
{
intValue = objMast.Head_Idno;
db.tblCommmissionMastHeads.DeleteObject(objMast);
db.SaveChanges();
IList <tblCommmissionMastDetl> objtblCommmissionMastDetl = (from obj in db.tblCommmissionMastDetls where obj.Head_Idno == intValue select obj).ToList();
if (objtblCommmissionMastDetl != null)
{
foreach (var lst in objtblCommmissionMastDetl)
{
db.tblCommmissionMastDetls.DeleteObject(lst);
db.SaveChanges();
}
intValue = 1;
}
}
else
{
intValue = 1;
}
}
}
catch (Exception Ex)
{
if (Convert.ToBoolean(Ex.InnerException.Message.Contains("The DELETE statement conflicted with the REFERENCE constraint")) == true)
{
intValue = -1;
}
}
return(intValue);
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
if (Convert.ToInt32(ddlItemName.SelectedValue) <= 0)
{
ShowMessageErr("Please select Item!"); ddlItemName.Focus();
return;
}
if (Convert.ToInt32(ddlState.SelectedValue) <= 0)
{
ShowMessageErr("Please select State!"); ddlState.Focus();
return;
}
Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
if (grdMain.Rows.Count > 0)
{
CommissionMasterDAL obj = new CommissionMasterDAL(); bool isinsert = false;
tblCommmissionMastHead objRGH = new tblCommmissionMastHead();
objRGH.Emp_Idno = empIdno;
objRGH.Item_Idno = Convert.ToInt32(ddlItemName.SelectedValue);
objRGH.Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateRate.Text));
objRGH.Com_Type = Convert.ToString(ddlType.SelectedIndex);
objRGH.Year_Idno = Convert.ToInt32(ddlDateRange.SelectedValue);
objRGH.FromCity_Idno = Convert.ToInt32(drpBaseCity.SelectedValue);
objRGH.State_Idno = Convert.ToInt32(ddlState.SelectedValue);
DtTemp = CreateDt();
hidsave.Value = "1";
int Id = 1;
foreach (GridViewRow dr in grdMain.Rows)
{
HiddenField hidTocity_Idno = (HiddenField)dr.FindControl("hidTocity_Idno");
TextBox txtCommissionAmnt = (TextBox)dr.FindControl("txtCommissionAmnt");
Label lblCityName = (Label)dr.FindControl("lblCityName");
if (Convert.ToDouble(Request.Form[txtCommissionAmnt.UniqueID]) >= 0)
{
Double amt = Convert.ToDouble(Request.Form[txtCommissionAmnt.UniqueID]);
ApplicationFunction.DatatableAddRow(DtTemp, Id, hidTocity_Idno.Value, lblCityName.Text, Request.Form[txtCommissionAmnt.UniqueID]);
}
Id++;
}
//Int64 HeadId = obj.HeadId(Convert.ToInt32(ddlItemName.SelectedValue), Convert.ToInt32(drpBaseCity.SelectedValue), Convert.ToInt32(ddlState.SelectedValue),Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateRate.Text)));
if (Convert.ToInt32(ddlItemName.SelectedValue) <= 0)
{
ShowMessageErr("Please select Item"); ddlItemName.Focus();
return;
}
else
{
Int64 value = obj.Delete(Convert.ToInt32(ddlItemName.SelectedValue), Convert.ToInt32(drpBaseCity.SelectedValue), Convert.ToInt32(ddlState.SelectedValue), Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateRate.Text)));
if (value > 0)
{
isinsert = obj.Insert(DtTemp, objRGH);
this.Clear();
}
else
{
ShowMessageErr("Record not saved successfully");
}
obj = null;
if (isinsert == true)
{
ShowMessage("Record save successfully");
}
else
{
ShowMessageErr("Record not saved succesfully");
}
}
}
else
{
ShowMessage("Please Enter Details");
ddlState.Focus();
return;
}
}
