private void userpref()
{
RateMastFTDAL objGrprepDAL = new RateMastFTDAL();
tblUserPref userpref = objGrprepDAL.selectuserpref();
iFromCity = Convert.ToInt32(userpref.BaseCity_Idno);
}
protected void imgBtnExcel_Click(object sender, ImageClickEventArgs e)
{
RateMastFTDAL objRateMst = new RateMastFTDAL();
DataTable dt = new DataTable();
dt = objRateMst.SelectDBDataExport(Convert.ToInt64(ddlLorryType.SelectedValue), Convert.ToInt32(drpBaseCity.SelectedValue), ApplicationFunction.ConnectionString());
Export(dt);
}
protected void lnkbtnSave_Click(object sender, EventArgs e)
{
RateMastFT objRGH = new RateMastFT();
objRGH.LorryTyp_idno = Convert.ToInt32(ddlLorryType.SelectedValue);
objRGH.Loc_Idno = Convert.ToInt32(drpBaseCity.SelectedValue);
List <RateMastFT> RgDlst = new List <RateMastFT>();
Int64 RateIdno = 0; bool isinsert = false;
DtTemp = (DataTable)ViewState["dt"];
if (DtTemp == null || DtTemp.Rows.Count <= 0)
{
ShowMessage("Please enter details");
return;
}
RateMastFTDAL obj = new RateMastFTDAL();
if (Convert.ToInt32(ddlLorryType.SelectedValue) <= 0)
{
ShowMessage("Please select Lorry Type"); ddlLorryType.Focus();
return;
}
else
{
using (TransactionScope Tran = new TransactionScope(TransactionScopeOption.Required))
{
int value = obj.Delete(Convert.ToInt32(ddlLorryType.SelectedValue), Convert.ToInt32(drpBaseCity.SelectedValue));
if (value > 0)
{
isinsert = obj.Insert(DtTemp, Convert.ToInt32(ddlDateRange.SelectedValue));
this.Clear();
}
else
{
ShowMessage("Record not saved successfully");
}
obj = null;
if (isinsert == true)
{
Tran.Complete();
ShowMessage("Record save successfully");
Clear();
}
else
{
Tran.Dispose();
ShowMessage("Record not saved successfully");
}
}
}
}
private void BindLorryType()
{
RateMastFTDAL obj = new RateMastFTDAL();
var lst = obj.BindLorryType();
obj = null;
if (lst.Count > 0)
{
ddlLorryType.DataSource = lst;
ddlLorryType.DataTextField = "Lorry_No";
ddlLorryType.DataValueField = "Lorry_Idno";
ddlLorryType.DataBind();
}
ddlLorryType.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void BindGridDB()
{
RateMastFTDAL objRateMstFT = new RateMastFTDAL();
DataTable dt1 = new DataTable();
DataRow Dr;
DtTemp = CreateDt();
dt1 = objRateMstFT.SelectDBData(Convert.ToInt64(ddlLorryType.SelectedValue), Convert.ToInt32(drpBaseCity.SelectedValue), ApplicationFunction.ConnectionString());
if (dt1 != null && dt1.Rows.Count > 0)
{
for (int i = 0; i < dt1.Rows.Count; i++)
{
Dr = DtTemp.NewRow();
Dr.BeginEdit();
Dr[0] = DtTemp.Rows.Count == 0 ? 1 : DtTemp.Rows.Count + 1;
Dr[1] = Convert.IsDBNull(dt1.Rows[i]["City_FIdno"]) ? "0" : Convert.ToString(dt1.Rows[i]["City_FIdno"]);
Dr[2] = Convert.IsDBNull(dt1.Rows[i]["City_FName"]) ? "0" : Convert.ToString(dt1.Rows[i]["City_FName"]);
Dr[3] = Convert.IsDBNull(dt1.Rows[i]["Lorry_Idno"]) ? "0" : Convert.ToString(dt1.Rows[i]["Lorry_Idno"]);
Dr[4] = Convert.IsDBNull(dt1.Rows[i]["Lorry_Type"]) ? "0" : Convert.ToString(dt1.Rows[i]["Lorry_Type"]);
Dr[5] = Convert.IsDBNull(dt1.Rows[i]["Rate_Date"]) ? "" : Convert.ToDateTime((dt1.Rows[i]["Rate_Date"])).ToString();
Dr[6] = Convert.IsDBNull(dt1.Rows[i]["ToCity_Idno"]) ? "0" : Convert.ToString(dt1.Rows[i]["ToCity_Idno"]);
Dr[7] = Convert.IsDBNull(dt1.Rows[i]["City_Name"]) ? "0" : Convert.ToString(dt1.Rows[i]["City_Name"]);
Dr[8] = Convert.IsDBNull(dt1.Rows[i]["Item_Rate"]) ? "0" : Convert.ToDouble(dt1.Rows[i]["Item_Rate"]).ToString("N2");
Dr.EndEdit();
DtTemp.Rows.Add(Dr);
}
ViewState["dt"] = DtTemp;
ViewState["newNdt"] = DtTemp;
BindGrid();
imgBtnExcel.Visible = true;
}
else
{
ViewState["dt"] = null;
BindGrid();
imgBtnExcel.Visible = false;
}
}
