public void BindMakerGrid()
{
BLL_Infra_Supplier objSupp = new BLL_Infra_Supplier();
int rowcount = ucCustomPagerItems.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
DataTable dt = objSupp.Get_Suppliers_List_Search(txtfilter.Text != "" ? txtfilter.Text : null, sortbycoloumn, sortdirection, null, null, ref rowcount);
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
if (dt.Rows.Count > 0)
{
gvSuppliers.DataSource = dt;
gvSuppliers.DataBind();
}
else
{
gvSuppliers.DataSource = dt;
gvSuppliers.DataBind();
}
}
protected void lnkAddNew_Click(object s, EventArgs e)
{
HiddenFlag.Value = "Add";
OperationMode = "Add Maker";
this.SetFocus("ctl00_MainContent_txtMakerName_AV");
txtAddress_AV.Text = "";
txtCreationDate_AV.Text = "";
txtEmail_AV.Text = "";
txtFax_AV.Text = "";
txtMakerCode_AV.Text = "";
txtMakerName_AV.Text = "";
txtPhone_AV.Text = "";
BLL_Infra_Supplier objSupp = new BLL_Infra_Supplier();
txtMakerCode_AV.Text = objSupp.Get_Next_MakerCode();
string AddMaker = String.Format("showModal('divadd',false);");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AddMaker", AddMaker, true);
}
protected void onUpdate(object s, CommandEventArgs e)
{
BLL_Infra_Supplier objSupp = new BLL_Infra_Supplier();
HiddenFlag.Value = "Edit";
OperationMode = "Edit Maker";
DataTable dtSuppDtl = objSupp.Get_Suppliers_Details(Convert.ToInt32(e.CommandArgument.ToString()));
ViewState["SUPPLIER_ID"] = dtSuppDtl.Rows[0]["SUPPLIER_ID"].ToString();
txtAddress_AV.Text = dtSuppDtl.Rows[0]["Address_1"].ToString();
txtCreationDate_AV.Text = dtSuppDtl.Rows[0]["Created_Date"].ToString();
txtEmail_AV.Text = dtSuppDtl.Rows[0]["Email1"].ToString();
txtFax_AV.Text = dtSuppDtl.Rows[0]["Fax1"].ToString();
txtMakerCode_AV.Text = dtSuppDtl.Rows[0]["Supplier_Code"].ToString();
txtMakerName_AV.Text = dtSuppDtl.Rows[0]["Supplier_Name"].ToString();
txtPhone_AV.Text = dtSuppDtl.Rows[0]["Phone1"].ToString();
ddlCountry_AV.ClearSelection();
ListItem list = ddlCountry_AV.Items.FindByValue(dtSuppDtl.Rows[0]["Country"].ToString());
if (list != null)
{
list.Selected = true;
}
txtCreationDate_AV.Enabled = false;
string AddMaker = String.Format("showModal('divadd',false);");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AddMaker", AddMaker, true);
}
protected void btnsave_Click(object s, EventArgs e)
{
BLL_Infra_Supplier objSupp = new BLL_Infra_Supplier();
if (HiddenFlag.Value == "Add")
{
objSupp.Ins_Supplier_Details(Session["USERID"].ToString(), txtMakerName_AV.Text, txtAddress_AV.Text, ddlCountry_AV.SelectedValue, txtEmail_AV.Text, txtPhone_AV.Text, txtFax_AV.Text, "", txtMakerCode_AV.Text);
}
else
{
objSupp.Upd_Suppliers_Details(Convert.ToInt32(ViewState["SUPPLIER_ID"].ToString()), Session["USERFULLNAME"].ToString(), txtMakerName_AV.Text, txtAddress_AV.Text, ddlCountry_AV.SelectedValue, txtEmail_AV.Text, txtPhone_AV.Text, txtFax_AV.Text, "");
}
String script = String.Format("parent.RefreshMakerFromChild();parent.hideModal('dvIframe');");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", script, true);
}
protected void ImgExpExcel_Click(object sender, EventArgs e)
{
BLL_Infra_Supplier objSupp = new BLL_Infra_Supplier();
int rowcount = ucCustomPagerItems.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
DataTable dt = objSupp.Get_Suppliers_List_Search(txtfilter.Text != "" ? txtfilter.Text : null, sortbycoloumn, sortdirection, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);
string[] HeaderCaptions = { "Vessel", "Port", "Arrival", "Berthing", "Departure", "Remaks" };
string[] DataColumnsName = { "Vessel_Name", "Port_Name", "Arrival", "Berthing", "Departure", "Port_Remarks" };
GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "PortCall", "Port Call", "");
}
protected void ImgExpExcel_Click(object sender, EventArgs e)
{
BLL_Infra_Supplier objSupp = new BLL_Infra_Supplier();
int rowcount = ucCustomPagerItems.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
DataTable dt = objSupp.Get_Suppliers_List_Search(txtfilter.Text != "" ? txtfilter.Text : null, sortbycoloumn, sortdirection, null, null, ref rowcount);
string[] HeaderCaptions = { "Code", "Name", "Country", "Email", "Address", "Phone", "Fax" };
string[] DataColumnsName = { "Supplier_Code", "Supplier_Name", "Country", "Email", "Address", "Phone", "fax" };
GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "Maker", "Maker", "");
}
protected void btnsave_Click(object s, EventArgs e)
{
BLL_Infra_Supplier objSupp = new BLL_Infra_Supplier();
if (HiddenFlag.Value == "Add")
{
objSupp.Ins_Supplier_Details(Session["USERID"].ToString(), txtMakerName_AV.Text, txtAddress_AV.Text, ddlCountry_AV.SelectedValue, txtEmail_AV.Text, txtPhone_AV.Text, txtFax_AV.Text, "", txtMakerCode_AV.Text);
}
else
{
objSupp.Upd_Suppliers_Details(Convert.ToInt32(ViewState["SUPPLIER_ID"].ToString()), Session["USERID"].ToString(), txtMakerName_AV.Text, txtAddress_AV.Text, ddlCountry_AV.SelectedValue, txtEmail_AV.Text, txtPhone_AV.Text, txtFax_AV.Text, "");
}
string hideMaker = String.Format("hideModal('divadd')");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hideMaker", hideMaker, true);
BindMakerGrid();
}
protected void onUpdate(object s, CommandEventArgs e)
{
BLL_Infra_Supplier objSupp = new BLL_Infra_Supplier();
HiddenFlag.Value = "Edit";
OperationMode = "Edit Port Call";
string[] arg = e.CommandArgument.ToString().Split(',');
int Port_call_ID = UDFLib.ConvertToInteger(arg[0]);
int Vessel_ID = UDFLib.ConvertToInteger(arg[1]);
DataTable dtPortCall = objPortCall.Get_PortCall_List(Convert.ToInt32(Port_call_ID), Vessel_ID);
txtPortCallID.Text = dtPortCall.Rows[0]["Port_Call_ID"].ToString();
txtVesselCode.Text = dtPortCall.Rows[0]["Vessel_Code"].ToString();
ddlVessel.SelectedValue = dtPortCall.Rows[0]["Vessel_ID"].ToString();
DDLPort.SelectedValue = dtPortCall.Rows[0]["Port_ID"].ToString();
dtpArrival.Text = dtPortCall.Rows[0]["Arrival"].ToString();
dtpBerthing.Text = dtPortCall.Rows[0]["Berthing"].ToString();
dtpDeparture.Text = dtPortCall.Rows[0]["Departure"].ToString();
txtPortRemark.Text = dtPortCall.Rows[0]["Port_Remarks"].ToString();
//ddlCountry_AV.ClearSelection();
//ListItem list = ddlCountry_AV.Items.FindByValue(dtSuppDtl.Rows[0]["Country"].ToString());
//if (list != null)
// list.Selected = true;
//txtCreationDate_AV.Enabled = false;
string AddMaker = String.Format("showModal('divadd',false);");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AddMaker", AddMaker, true);
}
protected void onUpdate(object s, CommandEventArgs e)
{
BLL_Infra_Supplier objSupp = new BLL_Infra_Supplier();
HiddenFlag.Value = "Edit";
OperationMode = "Edit Port Call";
string[] arg = e.CommandArgument.ToString().Split(',');
int Port_call_ID = UDFLib.ConvertToInteger(arg[0]);
int Vessel_ID = UDFLib.ConvertToInteger(arg[1]);
DataTable dtPortCall = objPortCall.Get_PortCall_List(Convert.ToInt32(Port_call_ID), Vessel_ID);
string AddMaker = String.Format("showModal('divadd',false);");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AddMaker", AddMaker, true);
}
public void NextMakerCode()
{
BLL_Infra_Supplier objSupp = new BLL_Infra_Supplier();
txtMakerCode_AV.Text = objSupp.Get_Next_MakerCode();
}
