protected void Page_Load(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty((string)Session["CompanyId"]) && string.IsNullOrEmpty((string)Session["Username"]))
{
Response.Redirect("~/Default.aspx", false);
}
else
{
if (!IsPostBack)
{
DataTable dtRights = CommonClasses.Execute("select UR_RIGHTS from USER_RIGHT where UR_IS_DELETE=0 AND UR_UM_CODE='" + Convert.ToInt32(Session["UserCode"]) + "' and UR_SM_CODE='105'");
right = dtRights.Rows.Count == 0 ? "00000000" : dtRights.Rows[0][0].ToString();
dtFilter.Clear();
if (dtFilter.Columns.Count == 0)
{
dtFilter.Columns.Add(new System.Data.DataColumn("FOS_CODE", typeof(string)));
dtFilter.Columns.Add(new System.Data.DataColumn("FOS_NO", typeof(string)));
dtFilter.Columns.Add(new System.Data.DataColumn("FOS_BATCH_NO", typeof(string)));
dtFilter.Columns.Add(new System.Data.DataColumn("FOS_DATE", typeof(string)));
//dtFilter.Columns.Add(new System.Data.DataColumn("CUST_NAME", typeof(string)));
dtFilter.Rows.Add(dtFilter.NewRow());
dgFillOffSheet.DataSource = dtFilter;
dgFillOffSheet.DataBind();
//dgFillOffSheet.Enabled = false;
}
LoadFillOffSheet();
}
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Issue Fill Off Sheet-View", "Page_Load", Ex.Message);
}
}
public bool Delete()
{
bool result = false;
try
{
//Update Master Table Flag
DL_DBAccess = new DatabaseAccessLayer();
SqlParameter[] par = new SqlParameter[5];
par[0] = new SqlParameter("@PK_CODE", RCP_CODE);
par[1] = new SqlParameter("@PK_Field", "RCP_CODE");
par[2] = new SqlParameter("@ES_DELETE", "1");
par[3] = new SqlParameter("@DELETE", "ES_DELETE");
par[4] = new SqlParameter("@TABLE_NAME", "RECIEPT_MASTER");
result = DL_DBAccess.Insertion_Updation_Delete("SP_CM_DELETE", par);
if (result == true)
{
//Delete from stock table
DataTable stockqty = CommonClasses.Execute("select RCPD_RCP_CODE,RCPD_AMOUNT from RECIEPT_DETAIL,RECIEPT_MASTER where RCPD_RCP_CODE=RCP_CODE AND RCPD_RCP_CODE='" + RCP_CODE + "'");
for (int k = 0; k < stockqty.Rows.Count; k++)
{
CommonClasses.Execute("Update INVOICE_MASTER set INM_RECIEVED_AMT=ISNULL(INM_RECIEVED_AMT,0)-" + stockqty.Rows[k]["RCPD_AMOUNT"] + " where INM_CODE='" + stockqty.Rows[k]["RCPD_INVOICE_CODE"] + "'");
}
}
return(result);
}
catch (Exception Ex)
{
CommonClasses.SendError("Reciept Entry", "Delete", Ex.Message);
return(false);
}
finally
{ }
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty((string)Session["CompanyId"]) && string.IsNullOrEmpty((string)Session["Username"]))
{
Response.Redirect("~/Default.aspx", false);
}
else
{
if (!IsPostBack)
{
DataTable dtRights = CommonClasses.Execute("select UR_RIGHTS from USER_RIGHT where UR_IS_DELETE=0 AND UR_UM_CODE='" + Convert.ToInt32(Session["UserCode"]) + "' and UR_SM_CODE='67'");
right = dtRights.Rows.Count == 0 ? "0000000" : dtRights.Rows[0][0].ToString();
LoadTallyDet();
if (dgTallySales.Rows.Count == 0)
{
if (dtFilter.Columns.Count == 0)
{
dgTallySales.Enabled = false;
dtFilter.Columns.Add(new System.Data.DataColumn("TTM_CODE", typeof(String)));
dtFilter.Columns.Add(new System.Data.DataColumn("TTM_NO", typeof(String)));
dtFilter.Columns.Add(new System.Data.DataColumn("TTM_DATE", typeof(String)));
dtFilter.Columns.Add(new System.Data.DataColumn("TTM_ENTRY_TYPE", typeof(String)));
dtFilter.Rows.Add(dtFilter.NewRow());
dgTallySales.DataSource = dtFilter;
dgTallySales.DataBind();
}
}
}
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Tally Transfer Sales", "Page_Load", Ex.Message);
}
}
private void LoadTaxHeadSales()
{
DataTable dt = new DataTable();
try
{
//BL_EmployeeMaster = new EmployeeMaster_BL();
//dt = CommonClasses.Execute("select SCT_DESC,SCT_CODE from SECTOR_MASTER where SCT_CM_COMP_ID=" + (string)Session["CompanyId"] + " and ES_DELETE=0 ORDER BY SCT_DESC");
dt = CommonClasses.Execute("select TALLY_CODE,TALLY_NAME from TALLY_MASTER where TALLY_COMP_ID=" + (string)Session["CompanyId"] + " and ES_DELETE=0");
ddlTaxAccHeadSales.DataSource = dt;
ddlTaxAccHeadSales.DataTextField = "TALLY_NAME";
ddlTaxAccHeadSales.DataValueField = "TALLY_CODE";
ddlTaxAccHeadSales.DataBind();
ddlTaxAccHeadSales.Items.Insert(0, new ListItem("Select Tax Acc Head for Sales", "0"));
ddlTaxSales.DataSource = dt;
ddlTaxSales.DataTextField = "TALLY_NAME";
ddlTaxSales.DataValueField = "TALLY_CODE";
ddlTaxSales.DataBind();
ddlTaxSales.Items.Insert(0, new ListItem("Select Tax Acc For Sales", "0"));
ddlTaxPurchase.DataSource = dt;
ddlTaxPurchase.DataTextField = "TALLY_NAME";
ddlTaxPurchase.DataValueField = "TALLY_CODE";
ddlTaxPurchase.DataBind();
ddlTaxPurchase.Items.Insert(0, new ListItem("Select Tax Acc For Purchase", "0"));
}
catch (Exception ex)
{
CommonClasses.SendError("Sale Tax Master", "Load Tax Head", ex.Message);
}
finally
{
//dt.Dispose();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dtRights = CommonClasses.Execute("select UR_RIGHTS from USER_RIGHT where UR_IS_DELETE=0 AND UR_UM_CODE='" + Convert.ToInt32(Session["UserCode"]) + "' and UR_SM_CODE='28'");
right = dtRights.Rows.Count == 0 ? "0000000" : dtRights.Rows[0][0].ToString();
//if (CommonClasses.ValidRights(int.Parse(right.Substring(0, 1)), this, "For Menu"))
//{
LoadComponent();
ddlSubComponent.Enabled = false;
chkAll.Checked = true;
ddlSCCodeNo.Enabled = false;
ChkCodeNoAll.Checked = true;
//}
//else
//{
// //PanelMsg.Visible = true;
// //lblmsg.Text = "<script> alert('You Have No Rights To View.');window.location='../Default.aspx'; </script>";
// Response.Write("<script> alert('You Have No Rights To View.');window.location='../Default.aspx'; </script>");
//}
}
}
private void LoadComponent(string CAT_CODE)
{
try
{
DataTable dt = CommonClasses.Execute("select I_CODE,I_CODENO,I_NAME FROM ITEM_MASTER WHERE I_CM_COMP_ID=" + (string)Session["CompanyId"] + " and I_CAT_CODE='" + CAT_CODE + "' and ES_DELETE=0 ORDER BY I_NAME");
ddlComponent.DataSource = dt;
ddlComponent.DataTextField = "I_CODENO";
ddlComponent.DataValueField = "I_CODE";
ddlComponent.DataBind();
ddlComponent.Items.Insert(0, new ListItem("Select Item Code", "0"));
ddlItemName.DataSource = dt;
ddlItemName.DataTextField = "I_NAME";
ddlItemName.DataValueField = "I_CODE";
ddlItemName.DataBind();
ddlItemName.Items.Insert(0, new ListItem("Select Item Name", "0"));
}
catch (Exception Ex)
{
CommonClasses.SendError("Stock Ledger Register", "LoadComponent", Ex.Message);
}
}
private void LoadInvoices()
{
try
{
DataTable FromInv = new DataTable();
FromInv = CommonClasses.Execute("SELECT DISTINCT INM_CODE,INM_NO FROM INVOICE_MASTER WHERE ES_DELETE=0 AND INM_INVOICE_TYPE=0 and INM_CM_CODE='" + Session["CompanyCode"].ToString() + "' AND INM_TYPE='TAXINV' ORDER BY INM_NO");
ddlFromInvNo.DataSource = FromInv;
ddlFromInvNo.DataTextField = "INM_NO";
ddlFromInvNo.DataValueField = "INM_CODE";
ddlFromInvNo.DataBind();
ddlFromInvNo.Items.Insert(0, new ListItem("Select Invoice No", "0"));
ddlToInvNo.DataSource = FromInv;
ddlToInvNo.DataTextField = "INM_NO";
ddlToInvNo.DataValueField = "INM_CODE";
ddlToInvNo.DataBind();
ddlToInvNo.Items.Insert(0, new ListItem("Select Invoice No", "0"));
}
catch (Exception Ex)
{
CommonClasses.SendError("Create VCM", "LoadInvoices", Ex.Message.ToString());
}
}
bool ModifyLog(string PrimaryKey)
{
try
{
CheckModifyLog = false;
//lblmsg.Visible = false;
//lblmsg.Text = "";
DataTable dt = CommonClasses.Execute("select MODIFY from PROJECT_CODE_MASTER where PROCM_CODE=" + PrimaryKey + " ");
if (Convert.ToBoolean(dt.Rows[0][0].ToString()) == true)
{
PanelMsg.Visible = true;
lblmsg.Text = "Record Used By Another User";
return(true);
}
}
catch (Exception exc)
{
CommonClasses.SendError("Project Code Master", "GridView1_RowEditing", exc.Message);
}
return(false);
}
public bool Save()
{
bool result = false;
DL_DBAccess = new DatabaseAccessLayer();
try
{
if (CheckExistSaveName())
{
CommonClasses.Execute("INSERT INTO SALES_TAX_MASTER(ST_CM_COMP_ID, ST_TAX_NAME, ST_ALIAS,ST_SALES_TAX, ST_TCS_TAX, ST_SET_OFF, ST_FORM_NO, ST_SALES_ACC_HEAD, ST_TAX_ACC_HEAD,ST_TAX_SALE_ACC,ST_TAX_PUR_ACC)VALUES(" + ST_CM_COMP_ID + ",'" + ST_TAX_NAME + "','" + ST_ALIAS + "','" + ST_SALES_TAX + "','" + ST_TCS_TAX + "','" + ST_SET_OFF + "','" + ST_FORM_NO + "','" + ST_SALES_ACC_HEAD + "','" + ST_TAX_ACC_HEAD + "','" + ST_TAX_SALE_ACC + "','" + ST_TAX_PUR_ACC + "')");
result = true;
}
else
{
Msg = "Tax Name Already Exist";
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Sales Tax Master Class", "Save", Ex.Message);
}
return(result);
}
private void ViewRec(string str)
{
try
{
DataTable dt = new DataTable();
dt = CommonClasses.Execute("SELECT * FROM ACCOUNT_LEDGER where L_CODE='" + Convert.ToInt32(ViewState["mlCode"].ToString()) + "'");
if (dt.Rows.Count > 0)
{
txtLedgerName.Text = dt.Rows[0]["L_NAME"].ToString();
ddlACType.SelectedValue = dt.Rows[0]["L_ACCTYPE"].ToString();
txtOpeningBal.Text = dt.Rows[0]["L_OPBAL"].ToString();
}
if (str == "MOD")
{
CommonClasses.SetModifyLock("ACCOUNT_LEDGER", "MODIFY", "L_CODE", Convert.ToInt32(ViewState["mlCode"].ToString()));
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Account Ledger Master", "ViewRec", Ex.Message);
}
}
protected void ddlSItemCodeno_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (ddlSItemCodeno.SelectedIndex != -1)
{
ddlSItemName.SelectedValue = ddlSItemCodeno.SelectedValue.ToString();
DataTable dt = new DataTable();
dt = CommonClasses.Execute("SELECT ITEM_UNIT_MASTER.I_UOM_CODE,ITEM_UNIT_MASTER.I_UOM_NAME FROM ITEM_UNIT_MASTER,ITEM_MASTER WHERE ITEM_UNIT_MASTER.I_UOM_CODE = ITEM_MASTER.I_UOM_CODE AND I_CODE='" + ddlSItemName.SelectedValue + "' and ITEM_MASTER.ES_DELETE=0");
if (dt.Rows.Count > 0)
{
txtSinUOM.Text = dt.Rows[0]["I_UOM_NAME"].ToString();
}
ddlSItemName.Focus();
}
}
catch (Exception ex)
{
CommonClasses.SendError("Bill of Material", "ddlSItemCodeno_SelectedIndexChanged", ex.Message);
}
}
bool ModifyLog(string PrimaryKey)
{
try
{
DataTable dt = CommonClasses.Execute("select MODIFY from ITEM_UNIT_MASTER where I_UOM_CODE=" + PrimaryKey + " ");
if (dt.Rows.Count > 0)
{
if (Convert.ToBoolean(dt.Rows[0][0].ToString()) == true)
{
ShowMessage("#Avisos", "Record used by another user", CommonClasses.MSG_Warning);
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
return(true);
}
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Unit Master - View", "ModifyLog", Ex.Message);
}
return(false);
}
private void LoadCountry()
{
DataTable dt = new DataTable();
try
{
CompanyMaster_BL = new CompanyMaster_BL();
dt = CommonClasses.Execute("select COUNTRY_CODE,COUNTRY_NAME from COUNTRY_MASTER where ES_DELETE=0 and COUNTRY_CM_COMP_ID=" + Session["CompanyId"] + "");
ddlCountry.DataSource = dt;
ddlCountry.DataTextField = "COUNTRY_NAME";
ddlCountry.DataValueField = "COUNTRY_CODE";
ddlCountry.DataBind();
ddlCountry.Items.Insert(0, new ListItem("------Country-------", "0"));
}
catch (Exception ex)
{
CommonClasses.SendError("Company Master", "LoadCountry", ex.Message);
}
finally
{
dt.Dispose();
}
}
bool ModifyLog(string PrimaryKey)
{
try
{
CheckModifyLog = false;
//lblmsg.Visible = false;
//lblmsg.Text = "";
DataTable dt = CommonClasses.Execute("SELECT MODIFY FROM ITEM_SUBCATEGORY_MASTER WHERE SCAT_CODE=" + PrimaryKey + " ");
if (Convert.ToBoolean(dt.Rows[0][0].ToString()) == true)
{
PanelMsg.Visible = true;
lblmsg.Text = "Record Used By Another User";
return(true);
}
}
catch (Exception exc)
{
CommonClasses.SendError("User Master", "GridView1_RowEditing", exc.Message);
}
return(false);
}
private void LoadFillOffSheet()
{
try
{
DataTable dt = new DataTable();
dt = CommonClasses.Execute("SELECT FOS_CODE,FOS_NO,BT_NO as FOS_BATCH_NO,convert(varchar,FOS_DATE,106) as FOS_DATE FROM FILL_OFF_SHEET,BATCH_MASTER WHERE BT_CODE=FOS_BT_CODE and FOS_CM_CODE= '" + Convert.ToInt32(Session["CompanyCode"]) + "' AND FILL_OFF_SHEET.ES_DELETE=0 ORDER BY FOS_NO DESC");
if (dt.Rows.Count == 0)
{
LoadStatus(txtString);
}
else
{
dgFillOffSheet.DataSource = dt;
dgFillOffSheet.DataBind();
// dgFillOffSheet.Enabled = false;
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Fill Off Sheet-View", "LoadFillOffSheet", Ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty((string)Session["CompanyId"]) && string.IsNullOrEmpty((string)Session["Username"]))
{
Response.Redirect("~/Default.aspx", false);
}
else
{
if (!IsPostBack)
{
DataTable dtRights = CommonClasses.Execute("select UR_RIGHTS from USER_RIGHT where UR_IS_DELETE=0 AND UR_UM_CODE='" + Convert.ToInt32(Session["UserCode"]) + "' and UR_SM_CODE='39'");
right = dtRights.Rows.Count == 0 ? "00000000" : dtRights.Rows[0][0].ToString();
LoadInward();
}
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Material Inward", "Page_Load", Ex.Message);
}
}
private void LoadPo()
{
try
{
DataTable dt = new DataTable();
dt = CommonClasses.Execute("SELECT * FROM PO_TYPE_MASTER WHERE PO_T_COMP_ID= '" + Convert.ToInt32(Session["CompanyId"]) + "' and ES_DELETE=0 order by PO_T_SHORT_NAME");
if (dt.Rows.Count == 0)
{
dtFilter.Clear();
dgPoTypeMaster.Enabled = false;
if (dtFilter.Columns.Count == 0)
{
dtFilter.Columns.Add(new System.Data.DataColumn("PO_T_CODE", typeof(String)));
dtFilter.Columns.Add(new System.Data.DataColumn("PO_T_SHORT_NAME", typeof(String)));
dtFilter.Columns.Add(new System.Data.DataColumn("PO_T_DESC", typeof(String)));
dtFilter.Columns.Add(new System.Data.DataColumn("PO_T_FIRST_LETTER", typeof(String)));
dtFilter.Rows.Add(dtFilter.NewRow());
dgPoTypeMaster.DataSource = dtFilter;
dgPoTypeMaster.DataBind();
}
}
else
{
dgPoTypeMaster.Enabled = true;
dgPoTypeMaster.DataSource = dt;
dgPoTypeMaster.DataBind();
}
}
catch (Exception Ex)
{
CommonClasses.SendError("PO Type Master", "LoadUser", Ex.Message);
}
}
private void LoadSupplier()
{
try
{
DataTable dt = new DataTable();
dt = CommonClasses.Execute("SELECT P_CODE,P_PARTY_CODE,P_NAME,P_CONTACT,P_PHONE FROM PARTY_MASTER WHERE P_CM_COMP_ID = '" + Convert.ToInt32(Session["CompanyId"]) + "' and P_TYPE=2 and ES_DELETE=0 ORDER BY P_NAME");
if (dt.Rows.Count == 0)
{
dgCustomerMaster.Enabled = false;
dtFilter.Clear();
if (dtFilter.Columns.Count == 0)
{
dtFilter.Columns.Add(new System.Data.DataColumn("P_CODE", typeof(String)));
dtFilter.Columns.Add(new System.Data.DataColumn("P_PARTY_CODE", typeof(String)));
dtFilter.Columns.Add(new System.Data.DataColumn("P_NAME", typeof(String)));
dtFilter.Columns.Add(new System.Data.DataColumn("P_CONTACT", typeof(String)));
dtFilter.Columns.Add(new System.Data.DataColumn("P_PHONE", typeof(String)));
dtFilter.Rows.Add(dtFilter.NewRow());
dgCustomerMaster.DataSource = dtFilter;
dgCustomerMaster.DataBind();
}
}
else
{
dgCustomerMaster.Enabled = true;
dgCustomerMaster.DataSource = dt;
dgCustomerMaster.DataBind();
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Supplier Master", "LoadCustomer", Ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Menu highlight code
//HtmlGenericControl home = (HtmlGenericControl)this.Page.Master.FindControl("Menus").FindControl("Sale");
//home.Attributes["class"] = "active";
//HtmlGenericControl home1 = (HtmlGenericControl)this.Page.Master.FindControl("Menus").FindControl("Sale1MV");
//home1.Attributes["class"] = "active";
if (!IsPostBack)
{
DataTable dtRights = CommonClasses.Execute("select UR_RIGHTS from USER_RIGHT where UR_IS_DELETE=0 AND UR_UM_CODE='" + Convert.ToInt32(Session["UserCode"]) + "' and UR_SM_CODE='25'");
right = dtRights.Rows.Count.Equals(0) ? "0000000" : dtRights.Rows[0][0].ToString();
//This code for disable calendar dates which is not in financial year
//txtFromDate_CalenderExtender.StartDate = Convert.ToDateTime(Session["OpeningDate"]);
//txtFromDate_CalenderExtender.EndDate = Convert.ToDateTime(Session["ClosingDate"]);
//CalendarExtender1.StartDate = Convert.ToDateTime(Session["OpeningDate"]);
//CalendarExtender1.EndDate = Convert.ToDateTime(Session["ClosingDate"]);
LoadCombos();
ddlCustomerName.Enabled = false;
ddlFinishedComponent.Enabled = false;
ddlComponent.Enabled = false;
txtFromDate.Enabled = false;
txtToDate.Enabled = false;
chkDateAll.Checked = true;
chkAllCustomer.Checked = true;
chkAllItem.Checked = true;
chkAllComp.Checked = true;
txtFromDate.Text = DateTime.Today.ToString("dd MMM yyyy");
txtToDate.Text = DateTime.Today.ToString("dd MMM yyyy");
//txtFromDate.Text = Convert.ToDateTime(Session["OpeningDate"]).ToString("dd MMM yyyy");
//txtToDate.Text = Convert.ToDateTime(Session["ClosingDate"]).ToString("dd MMM yyyy");
}
}
private void LoadCombos()
{
try
{
string str = "";
if (chkDateAll.Checked != true)
{
if (txtFromDate.Text != "" && txtToDate.Text != "")
{
str = str + "INM_DATE between '" + txtFromDate.Text + "' and '" + txtToDate.Text + "' and ";
}
}
if (chkAllItem.Checked != true)
{
if (ddlFinishedComponent.SelectedIndex != 9)
{
str = str + "I_CODE ='" + ddlFinishedComponent.SelectedValue + "' and ";
}
}
DataTable custdet = new DataTable();
custdet = CommonClasses.Execute("SELECT distinct PARTY_MASTER.P_CODE,PARTY_MASTER.P_NAME FROM ITEM_MASTER INNER JOIN INVOICE_DETAIL ON ITEM_MASTER.I_CODE = INVOICE_DETAIL.IND_I_CODE INNER JOIN INVOICE_MASTER ON INVOICE_DETAIL.IND_INM_CODE = INVOICE_MASTER.INM_CODE INNER JOIN PARTY_MASTER ON INVOICE_MASTER.INM_P_CODE = PARTY_MASTER.P_CODE where " + str + " ITEM_MASTER.ES_DELETE=0 and INVOICE_MASTER.ES_DELETE=0 and P_CM_COMP_ID=" + Session["CompanyId"].ToString() + " order by P_NAME");
ddlCustomerName.DataSource = custdet;
ddlCustomerName.DataTextField = "P_NAME";
ddlCustomerName.DataValueField = "P_CODE";
ddlCustomerName.DataBind();
ddlCustomerName.Items.Insert(0, new ListItem("Select Customer", "0"));
DataTable dtUserDet = new DataTable();
dtUserDet = CommonClasses.Execute("select LG_DOC_NO,LG_U_NAME,LG_U_CODE from LOG_MASTER where LG_DOC_NO='Customer Order Master' and LG_CM_COMP_ID=" + (string)Session["CompanyId"] + " group by LG_DOC_NO,LG_U_NAME,LG_U_CODE ");
}
catch (Exception Ex)
{
CommonClasses.SendError("Customer Order", "LoadCustomer", Ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty((string)Session["CompanyId"]) && string.IsNullOrEmpty((string)Session["Username"]))
{
Response.Redirect("~/Default.aspx", false);
}
else
{
if (!IsPostBack)
{
DataTable dtRights = CommonClasses.Execute("select UR_RIGHTS from USER_RIGHT where UR_IS_DELETE=0 AND UR_UM_CODE='" + Convert.ToInt32(Session["UserCode"]) + "' and UR_SM_CODE='16'");
right = dtRights.Rows.Count == 0 ? "0000000" : dtRights.Rows[0][0].ToString();
try
{
LoadTaxHeadSales();
LoadTaxHeadPurchase();
if (Request.QueryString[0].Equals("VIEW"))
{
BL_SalesTaxMaster = new SalesTaxMaster_BL();
mlCode = Convert.ToInt32(Request.QueryString[1].ToString());
ViewRec("VIEW");
}
else if (Request.QueryString[0].Equals("MODIFY"))
{
BL_SalesTaxMaster = new SalesTaxMaster_BL();
mlCode = Convert.ToInt32(Request.QueryString[1].ToString());
ViewRec("MOD");
}
txtTaxName.Focus();
}
catch (Exception ex)
{
CommonClasses.SendError("Sales Tax Master", "PageLoad", ex.Message);
}
}
}
}
private void ViewRec(string str)
{
try
{
DataTable dt = new DataTable();
dt = CommonClasses.Execute("SELECT * FROM CASH_BOOK_ENTRY where C_CODE='" + Convert.ToInt32(ViewState["mlCode"].ToString()) + "'");
if (dt.Rows.Count > 0)
{
txtDate.Text = Convert.ToDateTime(dt.Rows[0]["C_DATE"].ToString()).ToString("dd/MMM/yyyy");
ddlBank.SelectedValue = dt.Rows[0]["C_NAME"].ToString();
txtDeposit.Text = dt.Rows[0]["C_DEPOSIT"].ToString();
dllLedger.SelectedValue = dt.Rows[0]["C_L_CODE"].ToString();
txtWithdrawal.Text = dt.Rows[0]["C_WITHDRAWAL"].ToString();
txtRemark.Text = dt.Rows[0]["C_REMARK"].ToString();
txtOn_Account.Text = dt.Rows[0]["C_ON_ACC"].ToString();
txtCheque_No.Text = dt.Rows[0]["C_CHEQUE_NO"].ToString();
}
if (str == "VIEW")
{
txtWithdrawal.Enabled = false;
txtDeposit.Enabled = false;
txtRemark.Enabled = false;
txtDate.Enabled = false;
ddlBank.Enabled = false;
dllLedger.Enabled = false;
btnSubmit.Visible = false;
}
if (str == "MOD")
{
CommonClasses.SetModifyLock("CASH_BOOK_ENTRY", "MODIFY", "C_CODE", Convert.ToInt32(ViewState["mlCode"].ToString()));
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Cash Book Entry", "ViewRec", Ex.Message);
}
}
private void LoadCombos()
{
try
{
DataTable dtItemDet = new DataTable();
if (rbtType.SelectedIndex == 0)
{
dtItemDet = CommonClasses.Execute("Select I_CODE,I_CODENO,I_NAME,MR_BATCH_NO,MR_TYPE from ITEM_MASTER,MATERIAL_REQUISITION_MASTER where MATERIAL_REQUISITION_MASTER.MR_I_CODE=I_CODE and I_CM_COMP_ID='" + (string)Session["CompanyId"] + "' and MATERIAL_REQUISITION_MASTER.ES_DELETE=0 and MR_TYPE='Direct' ORDER BY I_NAME");
}
if (rbtType.SelectedIndex == 1)
{
dtItemDet = CommonClasses.Execute("Select I_CODE,I_CODENO,I_NAME,MR_BATCH_NO,MR_TYPE from ITEM_MASTER,MATERIAL_REQUISITION_MASTER where MATERIAL_REQUISITION_MASTER.MR_I_CODE=I_CODE and I_CM_COMP_ID='" + (string)Session["CompanyId"] + "' and MATERIAL_REQUISITION_MASTER.ES_DELETE=0 and MR_TYPE='As Per Order' ORDER BY I_NAME");
}
if (rbtType.SelectedIndex == 2)
{
dtItemDet = CommonClasses.Execute("Select I_CODE,I_CODENO,I_NAME,MR_BATCH_NO,MR_TYPE from ITEM_MASTER,MATERIAL_REQUISITION_MASTER where MATERIAL_REQUISITION_MASTER.MR_I_CODE=I_CODE and I_CM_COMP_ID='" + (string)Session["CompanyId"] + "' and MATERIAL_REQUISITION_MASTER.ES_DELETE=0 and MR_TYPE='As Per Batch' ORDER BY I_NAME");
}
//if (rbtType.SelectedIndex == 2)
//{
// dtItemDet = CommonClasses.Execute("Select I_CODE,I_CODENO,I_NAME,MR_BATCH_NO,MR_TYPE from ITEM_MASTER,MATERIAL_REQUISITION_MASTER where MATERIAL_REQUISITION_MASTER.MR_I_CODE=I_CODE and I_CM_COMP_ID='" + (string)Session["CompanyId"] + "' and MATERIAL_REQUISITION_MASTER.ES_DELETE=0 ORDER BY I_NAME");
//}
ddlFinishedComponent.DataSource = dtItemDet;
ddlFinishedComponent.DataTextField = "I_NAME";
ddlFinishedComponent.DataValueField = "I_CODE";
ddlFinishedComponent.DataBind();
ddlFinishedComponent.Items.Insert(0, new ListItem("Select Item Name", "0"));
}
catch (Exception Ex)
{
CommonClasses.SendError("Material Requisition Register", "LoadCustomer", Ex.Message);
}
}
void FillCombos()
{
try
{
DataTable dtItem = new DataTable();
if (chkAllCust.Checked == true)
{
dtItem = CommonClasses.Execute("SELECT I_NAME +' '+ I_CODENO as I_CODENO,I_CODE FROM CUSTOMER_SCHEDULE,CUSTOMER_SCHEDULE_DETAIL,ITEM_MASTER where CUSTOMER_SCHEDULE.CS_CODE=CUSTOMER_SCHEDULE_DETAIL.CS_CODE AND CSD_I_CODE=I_CODE AND CUSTOMER_SCHEDULE.ES_DELETE=0 AND DATEPART(MM,CS_MONTH)='" + Convert.ToDateTime(txtMonth.Text).Month + "'AND DATEPART(YYYY,CS_MONTH)='" + Convert.ToDateTime(txtMonth.Text).Year + "' ");
}
else
{
dtItem = CommonClasses.Execute("SELECT I_NAME +' '+ I_CODENO as I_CODENO,I_CODE FROM CUSTOMER_SCHEDULE,CUSTOMER_SCHEDULE_DETAIL,ITEM_MASTER where CUSTOMER_SCHEDULE.CS_CODE=CUSTOMER_SCHEDULE_DETAIL.CS_CODE AND CSD_I_CODE=I_CODE AND CUSTOMER_SCHEDULE.ES_DELETE=0 AND CS_P_CODE='" + ddlCustomer.SelectedValue + "' AND DATEPART(MM,CS_MONTH)='" + Convert.ToDateTime(txtMonth.Text).Month + "'AND DATEPART(YYYY,CS_MONTH)='" + Convert.ToDateTime(txtMonth.Text).Year + "' ");
}
ddlItemCode.DataSource = dtItem;
ddlItemCode.DataTextField = "I_CODENO";
ddlItemCode.DataValueField = "I_CODE";
ddlItemCode.DataBind();
ddlItemCode.Items.Insert(0, new ListItem("Select Item Code", "0"));
}
catch (Exception)
{
}
}
public void GetInfo()
{
DataTable dt = new DataTable();
//dt = GetRecords("GETINFO");
dt = dt = CommonClasses.Execute("SELECT ST_TAX_NAME, ST_ALIAS, ST_SALES_TAX, ST_TCS_TAX, ST_SET_OFF, ST_FORM_NO, ST_SALES_ACC_HEAD, ST_TAX_ACC_HEAD,ST_TAX_SALE_ACC,ST_TAX_PUR_ACC FROM SALES_TAX_MASTER WHERE ST_CODE='" + ST_CODE + "'");
if (dt.Rows.Count > 0)
{
//ST_CODE = Convert.ToInt32(dt.Rows[0]["ST_CODE"]);
ST_TAX_NAME = dt.Rows[0]["ST_TAX_NAME"].ToString();
ST_ALIAS = dt.Rows[0]["ST_ALIAS"].ToString();
ST_SALES_TAX = Convert.ToDouble(dt.Rows[0]["ST_SALES_TAX"]);
ST_TCS_TAX = Convert.ToDouble(dt.Rows[0]["ST_TCS_TAX"]);
ST_SET_OFF = Convert.ToDouble(dt.Rows[0]["ST_SET_OFF"]);
ST_FORM_NO = Convert.ToInt32(dt.Rows[0]["ST_FORM_NO"]);
ST_SALES_ACC_HEAD = dt.Rows[0]["ST_SALES_ACC_HEAD"].ToString();
ST_TAX_ACC_HEAD = dt.Rows[0]["ST_TAX_ACC_HEAD"].ToString();
ST_TAX_SALE_ACC = dt.Rows[0]["ST_TAX_SALE_ACC"].ToString();
ST_TAX_PUR_ACC = dt.Rows[0]["ST_TAX_PUR_ACC"].ToString();
}
}
protected void btnOkBatchNo_Click(object sender, EventArgs e)
{
try
{
txtBatchNo.Text = txtAutoBatchNo.Text;
DataTable dt = new DataTable();
dt = CommonClasses.Execute("Select BT_NO FROM BATCH_MASTER WHERE BT_CM_ID = " + (string)Session["CompanyId"] + " and BT_NO='" + txtBatchNo.Text + "' and ES_DELETE=0");
if (dt.Rows.Count > 0)
{
ShowMessage("#Avisos", "Batch Number Allready Exists", CommonClasses.MSG_Warning);
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
txtBatchNo.Focus();
return;
}
else
{
SaveRec();
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Batch Ticket", "btnOkBatchNo_Click", Ex.Message);
}
}
bool ModifyLog(string PrimaryKey)
{
try
{
DataTable dt = CommonClasses.Execute("select MODIFY from EXCISE_TARIFF_MASTER where E_CODE=" + PrimaryKey + " ");
if (dt.Rows.Count > 0)
{
if (Convert.ToBoolean(dt.Rows[0][0].ToString()) == true)
{
PanelMsg.Visible = true;
lblmsg.Text = "Record Used By Another Person";
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
return(true);
}
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Excise Tariff Master", "ModifyLog", Ex.Message);
}
return(false);
}
private void LoadItemCodes()
{
try
{
DataTable dtItemCode = new DataTable();
//dtItemCode = CommonClasses.Execute("select DISTINCT I_CODE,I_CODENO,I_NAME FROM ITEM_MASTER,INVOICE_MASTER,INVOICE_DETAIL WHERE INM_TYPE='OutSUBINM' AND INM_CODE = IND_INM_CODE AND IND_I_CODE = I_CODE AND I_CM_COMP_ID=" + (string)Session["CompanyId"] + " and ITEM_MASTER.ES_DELETE=0 and INVOICE_MASTER.ES_DELETE=0 ORDER BY I_NAME");
dtItemCode = CommonClasses.Execute("select DISTINCT I_CODE,I_CODENO,I_NAME FROM ITEM_MASTER,INVOICE_MASTER,INVOICE_DETAIL WHERE INM_TYPE='OutJWINM' AND INM_CODE = IND_INM_CODE AND IND_I_CODE = I_CODE AND I_CM_COMP_ID=" + (string)Session["CompanyId"] + " and ITEM_MASTER.ES_DELETE=0 and INVOICE_MASTER.ES_DELETE=0 ORDER BY I_NAME");
ddlItemCode.DataSource = dtItemCode;
ddlItemCode.DataTextField = "I_CODENO";
ddlItemCode.DataValueField = "I_CODE";
ddlItemCode.DataBind();
ddlItemCode.Items.Insert(0, new ListItem("Select Item Code", "0"));
ddlItemName.DataSource = dtItemCode;
ddlItemName.DataTextField = "I_NAME";
ddlItemName.DataValueField = "I_CODE";
ddlItemName.DataBind();
ddlItemName.Items.Insert(0, new ListItem("Select Item Name", "0"));
}
catch (Exception Ex)
{
CommonClasses.SendError("Customer Stock Ledger", "LoadItemCode", Ex.Message);
}
}
bool ModifyLog(string PrimaryKey)
{
try
{
DataTable dt = CommonClasses.Execute("select MODIFY from ITEM_MASTER where I_CODE=" + PrimaryKey + " ");
if (dt.Rows.Count > 0)
{
if (Convert.ToBoolean(dt.Rows[0][0].ToString()) == true)
{
PanelMsg.Visible = true;
lblmsg.Text = "Record Used By Another Person";
//ShowMessage("#Avisos", "Record used by another user", CommonClasses.MSG_Warning);
return(true);
}
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Item Master", "ModifyLog", Ex.Message);
}
return(false);
}
private void pendingQty()
{
#region PendingQty
try
{
// ddlPoNumber.Items.Insert(0, new ListItem("Select PO ", "0"));
//if (dt.Rows.Count > 0)
//{
if (ddlSupplier.SelectedIndex == 0)
{
PanelMsg.Visible = true;
lblmsg.Text = "Please Select Sub Contractor";
return;
}
dt = CommonClasses.Execute("SELECT (SUM(ISNULL(IWD_TUR_QTY,0))-SUM(ISNULL(IWD_REC_TUR_QTY,0))) AS PENDQTY FROM INWARD_MASTER,INWARD_DETAIL WHERE IWM_CODE=IWD_IWM_CODE AND IWM_P_CODE='" + ddlSupplier.SelectedValue + "' AND INWARD_MASTER.ES_DELETE=0");
if (dt.Rows.Count > 0)
{
//txtPendingQty.Text = string.Format("{0:0.000}", Convert.ToDouble(dt.Rows[0]["PENDQTY"].ToString()));
// dt = CommonClasses.Execute("select DISTINCT I_UOM_NAME from UNIT_MASTER UM,SUPP_PO_DETAILS SD where" + dt.Rows[0]["SPOD_UOM_CODE"] + "=UOM_CODE");
DataTable dtUOM = CommonClasses.Execute("SELECT I_UOM_CODE FROM ITEM_MASTER WHERE I_CODE='" + ddlItemCode.SelectedValue + "'");
if (dtUOM.Rows.Count > 0)
{
ddlUom.SelectedValue = dtUOM.Rows[0]["I_UOM_CODE"].ToString();
}
}
else
{
//txtPendingQty.Text = Convert.ToInt32(0).ToString();
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Material Inward", "PendingQty", Ex.Message);
}
#endregion
}
