private void userpref()
{
CommissionMasterDAL objGrprepDAL = new CommissionMasterDAL();
tblUserPref userpref = objGrprepDAL.selectuserpref();
iFromCity = Convert.ToInt32(userpref.BaseCity_Idno);
}
protected void imgPreviousDate_Click(object sender, ImageClickEventArgs e)
{
CommissionMasterDAL obj = new CommissionMasterDAL();
var lst = obj.PreviousDateList();
if (lst != null)
{
grdPreviusDates.DataSource = lst;
grdPreviusDates.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "JScript", "openModal();", true);
}
}
public void BindItems()
{
CommissionMasterDAL obj = new CommissionMasterDAL();
var lst = obj.GetItems();
obj = null;
ddlItemName.DataSource = lst;
ddlItemName.DataTextField = "Item_Name";
ddlItemName.DataValueField = "Item_Idno";
ddlItemName.DataBind();
ddlItemName.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void BindState()
{
CommissionMasterDAL obj = new CommissionMasterDAL();
var lst = obj.selectState();
obj = null;
ddlState.DataSource = lst;
ddlState.DataTextField = "State_Name";
ddlState.DataValueField = "State_Idno";
ddlState.DataBind();
ddlState.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void BindGridDB()
{
CommissionMasterDAL objRateMst = new CommissionMasterDAL();
DataTable dt1 = new DataTable();
dt1 = objRateMst.SelectDBData(Convert.ToInt64(ddlItemName.SelectedValue), Convert.ToInt64(drpBaseCity.SelectedValue), Convert.ToInt64(ddlState.SelectedValue), Convert.ToInt32(ddlDateRange.SelectedValue), ApplicationFunction.ConnectionString(), Convert.ToString(txtDateRate.Text.Trim()));
if (dt1 != null)
{
grdMain.DataSource = dt1;
grdMain.DataBind();
Grid.Visible = true;
}
else
{
Grid.Visible = false;
grdMain.DataSource = null;
grdMain.DataBind();
}
}
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;
}
}
