protected void grdMain_RowCommand1(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "cmdedit")
{
Populate(Convert.ToInt64(e.CommandArgument));
hidSaveType.Value = Convert.ToString(e.CommandArgument);
}
else if (e.CommandName == "cmddelete")
{
RateMasterRetailerDAL RM = new RateMasterRetailerDAL();
int value = RM.DeletePartyItemRate(Convert.ToInt64(e.CommandArgument));
if (value == 1)
{
BindGrid();
Clear();
ShowMessage("Record Deleted Successfully");
}
else
{
Clear();
BindGrid();
ShowMessage("Record Not Deleted!");
}
}
}
private void BindGrid()
{
Int64 Loc_id = Convert.ToInt64(drpBaseCity.SelectedValue);
Int64 Item_id = Convert.ToInt64(ddlItemName.SelectedValue);
Int64 Party_Id = Convert.ToInt64(ddlPartyName.SelectedValue);
Int64 TranType_Idno = Convert.ToInt64(ddlTranType.SelectedValue);
RateMasterRetailerDAL obj = new RateMasterRetailerDAL();
dtGrid = obj.SelectPartyItemRateList(Party_Id, Loc_id, Item_id, TranType_Idno, ApplicationFunction.ConnectionString());
if (dtGrid != null)
{
GridDiv.Visible = true;
grdMain.DataSource = dtGrid;
grdMain.DataBind();
if (IsWeight == false)
{
//grdMain.HeaderRow.Cells[5].Visible = false;
grdMain.Columns[5].Visible = false;
}
else
{
//grdMain.HeaderRow.Cells[5].Visible = true;
grdMain.Columns[5].Visible = true;
}
//hidSaveType.Value = "0";
}
}
private void userpref()
{
RateMasterRetailerDAL objGrprepDAL = new RateMasterRetailerDAL();
tblUserPref userpref = objGrprepDAL.selectuserpref();
iFromCity = Convert.ToInt32(userpref.BaseCity_Idno);
//IsWeight = Convert.ToBoolean(userpref.WeightWise_Rate);
}
public void BindItems()
{
RateMasterRetailerDAL obj = new RateMasterRetailerDAL();
var lst = obj.GetItems();
ddlItemName.DataSource = lst;
ddlItemName.DataTextField = "Item_Name";
ddlItemName.DataValueField = "Item_Idno";
ddlItemName.DataBind();
ddlItemName.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void BindViaCity()
{
RateMasterRetailerDAL obj = new RateMasterRetailerDAL();
var lst = obj.SelectCityCombo();
obj = null;
ddlCityVia.DataSource = lst;
ddlCityVia.DataTextField = "City_Name";
ddlCityVia.DataValueField = "City_Idno";
ddlCityVia.DataBind();
ddlCityVia.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void Populate(Int64 PRateID)
{
RateMasterRetailerDAL obj = new RateMasterRetailerDAL();
DataSet dt = obj.SelectPartyItemRate(PRateID, ApplicationFunction.ConnectionString());
try
{
lnkbtnNew.Visible = true;
if (dt != null && dt.Tables[0].Rows.Count > 0)
{
ddlCity.SelectedValue = Convert.ToString(dt.Tables[0].Rows[0]["ToCity_Idno"]);
ddlCityVia.SelectedValue = Convert.ToString(dt.Tables[0].Rows[0]["FromCityId"]);
drpBaseCity.SelectedValue = Convert.ToString(dt.Tables[0].Rows[0]["Loc_Idno"]);
txtItemRate.Text = Convert.ToString(dt.Tables[0].Rows[0]["Item_Rate"]);
txtDateRate.Text = Convert.ToDateTime(dt.Tables[0].Rows[0]["Rate_Date"]).ToString("dd-MM-yyyy");
ddlPartyName.SelectedValue = Convert.ToString(dt.Tables[0].Rows[0]["Party_Idno"]);
ddlItemName.SelectedValue = Convert.ToString(dt.Tables[0].Rows[0]["Item_Idno"]);
txt_Weight.Text = Convert.ToString(dt.Tables[0].Rows[0]["Item_Weight"]);
bool Is_Weight = Convert.ToBoolean(dt.Tables[0].Rows[0]["IsWeight"]);
ddlDateRange.SelectedValue = Convert.ToString(dt.Tables[0].Rows[0]["Year_Idno"]);
ddlTranType.SelectedValue = Convert.ToString(dt.Tables[0].Rows[0]["TranType_Idno"]);
if (Is_Weight == true)
{
txt_Weight.Visible = true;
rfv_Weight.Enabled = true;
lblWeight.Visible = true;
}
else
{
txt_Weight.Visible = false;
lblWeight.Visible = false;
rfv_Weight.Enabled = false;
}
}
}
catch (Exception e)
{
}
}
protected void lnkbtnSave_Click(object sender, EventArgs e)
{
if (drpBaseCity.SelectedValue == "0")
{
ShowMessageErr("Please Select Location!");
return;
}
if (ddlPartyName.SelectedValue == "0")
{
ShowMessageErr("Please Select Party!");
return;
}
if (ddlItemName.SelectedValue == "0")
{
ShowMessageErr("Please Select Item!");
return;
}
if (ddlCityVia.SelectedValue == "0")
{
ShowMessageErr("Please Select To Via City!");
return;
}
if (ddlCity.SelectedValue == "0")
{
ShowMessageErr("Please Select To City!");
return;
}
if (Convert.ToDouble(txt_Weight.Text) <= 0.00 && IsWeight == true)
{
ShowMessageErr("Please Enter Weight More than 0!");
return;
}
Int64 empIdno = Convert.ToInt64((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
tblPartyRateRetailerMast obj = new tblPartyRateRetailerMast();
obj.Loc_Idno = Convert.ToInt64(drpBaseCity.SelectedValue);
obj.Party_Idno = Convert.ToInt64(ddlPartyName.SelectedValue);
obj.Item_Idno = Convert.ToInt64(ddlItemName.SelectedValue);
obj.Rate_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateRate.Text.Trim()).ToString());
obj.FrmCity_Idno = Convert.ToInt64(ddlCityVia.SelectedValue);
obj.ToCity_Idno = Convert.ToInt64(ddlCity.SelectedValue);
obj.Item_Rate = Convert.ToDecimal(txtItemRate.Text.Trim());
obj.Emp_Idno = empIdno;
obj.Date_Added = Convert.ToDateTime(DateTime.Now);
obj.Date_Modified = Convert.ToDateTime(DateTime.Now);
obj.Status = true;
obj.Year_idno = Convert.ToInt32(ddlDateRange.SelectedValue);
obj.TranType_Idno = Convert.ToInt64(ddlTranType.SelectedValue);
obj.Tran_Type = Convert.ToString(ddlTranType.SelectedItem.Text);
RateMasterRetailerDAL RM = new RateMasterRetailerDAL();
if (IsWeight == false)
{ // For Without Weight Wise
obj.Item_Weight = 0;
obj.IsWeight = false;
}
else
{
obj.Item_Weight = Convert.ToDecimal(txt_Weight.Text);
obj.IsWeight = true;
}
if ((hidSaveType.Value != "") && (Convert.ToInt64(hidSaveType.Value)) > 0)
{
int value = RM.UpdatePartyItemRate(obj, Convert.ToInt64(Convert.ToInt64(hidSaveType.Value)));
if (value == 1)
{
BindGrid();
Clear();
ShowMessage("Record Updated Successfully");
}
else if (value == 2)
{
BindGrid();
ShowMessageErr("Record Already Exists!");
}
else
{
BindGrid();
ShowMessageErr("Record Not Updated!");
}
}
else
{
int value = RM.InsertPartyItemRate(obj);
if (value == 1)
{
BindGrid();
Clear();
ShowMessage("Record Inserted Successfully");
}
else if (value == 2)
{
BindGrid();
Clear();
ShowMessageErr("Record Already Exists!");
}
else
{
BindGrid();
Clear();
ShowMessageErr("Record Not Inserted!");
}
}
}
