private void BindGrid()
{
Int64 Loc_id = Convert.ToInt64(drpBaseCity.SelectedValue);
Int64 Item_id = Convert.ToInt64(ddlItemName.SelectedValue);
Int64 Party_Id = Convert.ToInt64(ddlPartyName.SelectedValue);
RateMasterDAL obj = new RateMasterDAL();
dtGrid = obj.SelectPartyItemRateListReport("SelectRateRep", Convert.ToInt32(ddlDateRange.SelectedValue), Convert.ToString(txtDateFrom.Text.Trim()), Convert.ToString(txtDateTo.Text), Convert.ToInt32(ddlPartyName.SelectedValue), Loc_id, Item_id, ApplicationFunction.ConnectionString());
if (dtGrid != null)
{
lblTotalRecord.Text = "T. Record (s): " + Convert.ToString(dtGrid.Rows.Count);
//GridDiv.Visible = true;
grdMain.DataSource = dtGrid;
grdMain.DataBind();
imgBtnExcel.Visible = true;
}
else
{
lblTotalRecord.Text = "0";
grdMain.DataSource = null;
grdMain.DataBind();
imgBtnExcel.Visible = false;
}
}
//protected void ddlDateRange_SelectedIndexChanged(object sender, EventArgs e)
//{
// SetDate();
// drpBaseCity.Focus();
//}
//protected void drpBaseCity_SelectedIndexChanged(object sender, EventArgs e)
//{
// if (drpBaseCity.SelectedIndex > 0)
// {
// ClearAll();
// grdMain.DataSource = null;
// grdMain.DataBind();
// drpBaseCity.SelectedValue = HidFrmCityIdno.Value;
// ddlItemratetYP.SelectedValue = HiItemRateType.Value;
// BindGridDB();
// }
// else if (drpBaseCity.SelectedIndex <= 0)
// {
// ddlItemName.SelectedIndex = 0;
// }
// ddlItemName.Focus();
//}
//protected void ddlCity_SelectedIndexChanged(object sender, EventArgs e)
//{
// if (ddlItemName.SelectedIndex > 0 && drpBaseCity.SelectedIndex > 0)
// {
// BindGridDB();
// DtTemp = (DataTable)ViewState["dt"];
// if (DtTemp != null && DtTemp.Rows.Count > 0)
// {
// foreach (DataRow row in DtTemp.Rows)
// {
// if ((Convert.ToInt32(row["ToCity_Idno"]) == Convert.ToInt32(ddlCity.SelectedValue)) && (Convert.ToDateTime(row["Rate_Date"]).ToString("dd-MM-yyyy") == Convert.ToString(txtDateRate.Text)))
// {
// string msg = "Same city and date can not be selected!";
// ddlCity.SelectedIndex = 0;
// ddlCity.Focus();
// this.ShowMessage(msg);
// return;
// }
// }
// }
// txtItemWighRate.Focus();
// RateMasterDAL obj = new RateMasterDAL();
// txtKMS.Text = Convert.ToString(obj.Kms(Convert.ToInt32(drpBaseCity.SelectedValue), Convert.ToInt32(ddlCityVia.SelectedValue), Convert.ToInt32(ddlCity.SelectedValue)));
// }
// else
// {
// grdMain.DataSource = null;
// grdMain.DataBind();
// ShowMessage("Please Select From City And Product Name");
// }
//}
#endregion
#region Grid Events...
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "cmdedit")
{
Populate(Convert.ToInt64(e.CommandArgument));
hidSaveType.Value = Convert.ToString(e.CommandArgument);
}
else if (e.CommandName == "cmddelete")
{
RateMasterDAL RM = new RateMasterDAL();
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);
RateMasterDAL obj = new RateMasterDAL();
dtGrid = obj.SelectPartyItemRateList(Party_Id, Loc_id, Item_id, 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()
{
RateMasterDAL objGrprepDAL = new RateMasterDAL();
tblUserPref userpref = objGrprepDAL.selectuserpref();
iFromCity = Convert.ToInt32(userpref.BaseCity_Idno);
IsWeight = Convert.ToBoolean(userpref.WeightWise_Rate);
}
public void BindItems()
{
RateMasterDAL obj = new RateMasterDAL();
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()
{
RateMasterDAL obj = new RateMasterDAL();
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)
{
RateMasterDAL obj = new RateMasterDAL();
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"]);
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());
tblPartyRateMast obj = new tblPartyRateMast();
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);
RateMasterDAL RM = new RateMasterDAL();
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)), IsWeight);
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, IsWeight);
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!");
}
}
}
