void FillCombos()
{
try
{
DataTable dtItem = CommonClasses.Execute("SELECT I_NAME,I_CODENO,I_CODE FROM ITEM_MASTER WHERE I_CAT_CODE=-2147483648 AND ES_DELETE=0");
ddlComponent.DataSource = dtItem;
ddlComponent.DataTextField = "I_CODENO";
ddlComponent.DataValueField = "I_CODE";
ddlComponent.DataBind();
ddlComponent.Items.Insert(0, new ListItem("Select Item Code", "0"));
ddlItemName.DataSource = dtItem;
ddlItemName.DataTextField = "I_NAME";
ddlItemName.DataValueField = "I_CODE";
ddlItemName.DataBind();
ddlItemName.Items.Insert(0, new ListItem("Select Item Name", "0"));
}
catch (Exception)
{
}
}
bool ModifyLog(string PrimaryKey)
{
try
{
CheckModifyLog = false;
DataTable dt = CommonClasses.Execute("select MODIFY from ACCOUNT_LEDGER where L_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);
return(true);
}
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Account Ledger Master", "ModifyLog", Ex.Message);
}
return(false);
}
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();
}
}
bool CheckValid()
{
bool flag = false;
try
{
if (ddlType.SelectedIndex == 0)
{
flag = false;
}
else if (ddlType.SelectedIndex == 1 && ddlMatReqNo.SelectedIndex == 0)
{
flag = false;
}
else if (ddlItemName.SelectedIndex == 0)
{
flag = false;
}
else if (txtDepartment.Text == "")
{
flag = false;
}
else if (dgvPurReqDet.Enabled != true)
{
flag = false;
}
else
{
flag = true;
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Purchase Requisition", "CheckValid", Ex.Message);
}
return(flag);
}
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);
}
}
//#region LoadCurr
//private void LoadCurr()
//{
// try
// {
// DataTable dt = CommonClasses.Execute("SELECT CURR_CODE,CURR_NAME FROM CURRANCY_MASTER WHERE ES_DELETE = 0 AND CURR_CM_COMP_ID = " + (string)Session["CompanyId"] + " ORDER BY CURR_NAME");
// ddlLedger.DataSource = dt;
// ddlLedger.DataTextField = "CURR_NAME";
// ddlLedger.DataValueField = "CURR_CODE";
// ddlLedger.DataBind();
// ddlLedger.Items.Insert(0, new ListItem("Select Ledger", "0"));
// ddlLedger.SelectedIndex = -1;
// }
// catch (Exception Ex)
// {
// CommonClasses.SendError("Export PO", "LoadIName", Ex.Message);
// }
//}
//#endregion
#region GetValues
public bool GetValues(string str)
{
bool res = false;
try
{
if (str == "VIEW")
{
ddlCustomer.SelectedValue = BL_RecieptEntry.RCP_P_CODE.ToString();
txtRCPno.Text = BL_RecieptEntry.RCP_NO.ToString();
txtChequeNo.Text = BL_RecieptEntry.RCP_CHEQUE_NO.ToString();
txtRCPDate.Text = BL_RecieptEntry.RCP_DATE.ToString("dd MMM YYYY");
txtChequeDate.Text = BL_RecieptEntry.RCP_CHEQUE_DATE.ToString("dd MMM YYYY");
ddlLedger.SelectedValue = BL_RecieptEntry.RCP_LEDGER_CODE.ToString();
txtAmount.Text = BL_RecieptEntry.RCP_AMOUNT.ToString();
}
else if (str == "VIEW")
{
ddlCustomer.Enabled = false;
txtRCPno.Enabled = false;
txtChequeNo.Enabled = false;
txtChequeDate.Enabled = false;
txtRCPDate.Enabled = false;
BtnInsert.Visible = false;
btnSubmit.Visible = false;
ddlLedger.Enabled = false;
txtAmount.Enabled = false;
}
res = true;
}
catch (Exception ex)
{
CommonClasses.SendError("Reciept Entry", "GetValues", ex.Message);
}
return(res);
}
private void LoadCombos()
{
try
{
DataTable custdet = new DataTable();
custdet = CommonClasses.Execute(" SELECT DISTINCT P_CODE,P_NAME FROM CUSTREJECTION_MASTER,PARTY_MASTER where CR_P_CODE =P_CODE AND CUSTREJECTION_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 dtItemDet = new DataTable();
dtItemDet = CommonClasses.Execute("SELECT DISTINCT I_CODE,I_CODENO,I_NAME FROM CUSTREJECTION_MASTER,CUSTREJECTION_DETAIL,ITEM_MASTER where CR_CODE =CD_CR_CODE AND CUSTREJECTION_MASTER.ES_DELETE=0 AND I_CODE=CD_I_CODE AND I_CM_COMP_ID=" + (string)Session["CompanyId"] + " and ITEM_MASTER.ES_DELETE=0 ORDER BY I_NAME");
ddlFinishedComponent.DataSource = dtItemDet;
ddlFinishedComponent.DataTextField = "I_CODENO";
ddlFinishedComponent.DataValueField = "I_CODE";
ddlFinishedComponent.DataBind();
ddlFinishedComponent.Items.Insert(0, new ListItem("Select Item code", "0"));
ddlItemName.DataSource = dtItemDet;
ddlItemName.DataTextField = "I_NAME";
ddlItemName.DataValueField = "I_CODE";
ddlItemName.DataBind();
ddlItemName.Items.Insert(0, new ListItem("Select Item Name", "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 Rejection Register", "LoadCustomer", 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", PAYM_CODE);
par[1] = new SqlParameter("@PK_Field", "PAYM_CODE");
par[2] = new SqlParameter("@ES_DELETE", "1");
par[3] = new SqlParameter("@DELETE", "ES_DELETE");
par[4] = new SqlParameter("@TABLE_NAME", "PAYMENT_MASTER");
result = DL_DBAccess.Insertion_Updation_Delete("SP_CM_DELETE", par);
if (result == true)
{
//Delete from stock table
DataTable stockqty = CommonClasses.Execute("select PAYMD_PAYM_CODE,PAYMD_AMOUNT from PAYMENT_DETAIL,PAYMENT_MASTER where PAYMD_PAYM_CODE=PAYM_CODE AND PAYMD_PAYM_CODE='" + PAYM_CODE + "'");
for (int k = 0; k < stockqty.Rows.Count; k++)
{
CommonClasses.Execute("Update BILL_PASSING_MASTER set BPM_PAID_AMT=ISNULL(BPM_PAID_AMT,0)-" + stockqty.Rows[k]["PAYMD_AMOUNT"] + " where BPM_CODE='" + stockqty.Rows[k]["PAYMD_INVOICE_CODE"] + "'");
}
}
return(result);
}
catch (Exception Ex)
{
CommonClasses.SendError("Payemt 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='66'");
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 Purchase", "Page_Load", Ex.Message);
}
}
private bool CheckValid()
{
bool flag = false;
try
{
if (txtWithdrawal.Text.Trim() == "")
{
flag = false;
}
else if (txtDeposit.Text.Trim() == "")
{
flag = false;
}
else if (txtRemark.Text.Trim() == "")
{
flag = false;
}
else if (ddlBank.SelectedIndex == 0)
{
flag = false;
}
else if (dllLedger.SelectedIndex == 0)
{
flag = false;
}
else
{
flag = true;
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Cash Book Entry", "CheckValid", Ex.Message);
}
return(flag);
}
protected void dgAMCDet_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
if (CommonClasses.ValidRights(int.Parse(right.Substring(4, 1)), this, "For Delete"))
{
if (!ModifyLog(((Label)(dgAMCDet.Rows[e.RowIndex].FindControl("lblWO_AMC_CODE"))).Text))
{
string WO_AMC_CODE = ((Label)(dgAMCDet.Rows[e.RowIndex].FindControl("lblWO_AMC_CODE"))).Text;
bool flag = CommonClasses.Execute1("UPDATE WORK_AMC_ORDER_MASTER SET ES_DELETE = 1 WHERE WO_AMC_CODE='" + Convert.ToInt32(WO_AMC_CODE) + "'");
if (flag == true)
{
CommonClasses.WriteLog("Annual Mainteance Contract", "Delete", "Annual Mainteance Contract", WO_AMC_CODE, Convert.ToInt32(WO_AMC_CODE), Convert.ToInt32(Session["CompanyId"]), Convert.ToInt32(Session["CompanyCode"]), (Session["Username"].ToString()), Convert.ToInt32(Session["UserCode"]));
PanelMsg.Visible = true;
lblmsg.Text = "Record deleted successfully";
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
}
LoadACDetail();
}
}
else
{
PanelMsg.Visible = true;
lblmsg.Text = "You have no rights to delete";
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
//ShowMessage("#Avisos", "You Have No Rights To Delete", CommonClasses.MSG_Erro);
return;
}
}
catch (Exception Ex)
{
CommonClasses.SendError("AMC Transaction", "dgDetailPO_RowDeleting", Ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (ddlCustomer.SelectedIndex == 0)
{
PanelMsg.Visible = true;
lblmsg.Text = "Select Customer Name";
// ShowMessage("#Avisos", "", CommonClasses.MSG_Warning);
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
//PanelMsg.Visible = true;
//lblmsg.Text = "Select Customer Name";
ddlCustomer.Focus();
return;
}
if (dgMainDC.Enabled && dgMainDC.Rows.Count > 0)
{
SaveRec();
}
else
{
PanelMsg.Visible = true;
lblmsg.Text = "Record Not Exist In Table";
// ShowMessage("#Avisos", "", CommonClasses.MSG_Warning);
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
//PanelMsg.Visible = true;
//lblmsg.Text = "Record Not Exist In Grid View";
return;
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Delivery Challan", "btnSubmit_Click", Ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (((DataTable)ViewState["dt"]).Rows.Count > 0)
{
//foreach (DataRow item in ((DataTable)ViewState["dt"]).Rows)
//{
if (CommonClasses.Execute1("UPDATE ITEM_MASTER SET I_TEMP_CURRENT_BAL=0 WHERE (I_TEMP_CURRENT_BAL <> 0) AND (ES_DELETE = 0) "))
{
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "alert('Cleared');", true);
Response.Redirect("~/Masters/ADD/UtilityDefault.aspx", false);
}
else
{
PanelMsg.Visible = true;
lblmsg.Text = "Not cleared";
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert1();", true);
return;
}
//}
}
else
{
PanelMsg.Visible = true;
lblmsg.Text = "Record not found";
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert1();", true);
return;
}
}
catch (Exception ex)
{
CommonClasses.SendError("Clear Unused Stock", "btnSubmit_Click", ex.Message.ToString());
}
}
protected void btnShow_Click(object sender, EventArgs e)
{
try
{
//DateTime dt = new DateTime();
//dt = Convert.ToDateTime(txtMonth.Text);
//Session["Date"] = dt;
if (chkAll.Checked == true && chkAllSupplier.Checked == true)
{
Response.Redirect("~/RoportForms/ADD/SupplierTypeMaster.aspx?Title=" + Title + "&All_code=" + chkAll.Checked.ToString() + "&val_code=" + ddlSupplierName.SelectedValue.ToString() + "&SupplierAll_code=" + chkAllSupplier.Checked.ToString() + "", false);
}
if (chkAll.Checked == false && chkAllSupplier.Checked == true)
{
Response.Redirect("~/RoportForms/ADD/SupplierTypeMaster.aspx?Title=" + Title + "&All_code=" + chkAll.Checked.ToString() + "&val_code=" + ddlSupplierName.SelectedValue.ToString() + "&SupplierAll_code=" + chkAllSupplier.Checked.ToString() + "", false);
}
if (chkAll.Checked == true && chkAllSupplier.Checked == false)
{
Response.Redirect("~/RoportForms/ADD/SupplierTypeMaster.aspx?Title=" + Title + "&All_code=" + chkAll.Checked.ToString() + "&val_code=" + ddlSupplierCode.SelectedValue.ToString() + "&SupplierAll_code=" + chkAllSupplier.Checked.ToString() + "", false);
}
if (chkAll.Checked == false && chkAllSupplier.Checked == false)
{
if (ddlSupplierName.SelectedIndex != 0 && ddlSupplierCode.SelectedIndex != 0)
{
Response.Redirect("~/RoportForms/ADD/SupplierTypeMaster.aspx?Title=" + Title + "&All_code=" + chkAll.Checked.ToString() + "&val_code=" + ddlSupplierName.SelectedValue.ToString() + "&SupplierAll_code=" + chkAllSupplier.Checked.ToString() + "", false);
}
else
{
ShowMessage("#Avisos", "Please Select Sector ", CommonClasses.MSG_Warning);
return;
}
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Supplier Master Register", "btnShow_Click", Ex.Message);
}
}
bool CheckValid()
{
bool flag = false;
try
{
if (txtScheduleDate.Text == "")
{
flag = false;
}
else
{
flag = true;
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Issue To Production", "CheckValid", Ex.Message);
}
return(flag);
}
public bool SaveLogin()
{
bool result = false;
try
{
DL_DBAccess = new DatabaseAccessLayer();
SqlParameter[] par = new SqlParameter[1];
par[0] = new SqlParameter("@LoginCode", LoginCode);
result = DL_DBAccess.Insertion_Updation_Delete("SP_CM_UpdateRemoveLoginFlag", par);
if (result == true)
{
Msg = "Data Updated Successfully";
}
}
catch (Exception ex)
{
CommonClasses.SendError("Remove Modify Lock Class", "SaveLogin", ex.Message);
}
return(result);
}
protected void chkFormToAll_CheckedChanged(object sender, EventArgs e)
{
try
{
if (chkFormToAll.Checked == true)
{
txtFormDate.Enabled = false;
txtToDate.Enabled = false;
}
else
{
txtFormDate.Enabled = true;
txtToDate.Enabled = true;
txtFormDate.Attributes.Add("readonly", "readonly");
txtToDate.Attributes.Add("readonly", "readonly");
return;
}
}
catch (Exception ex)
{
CommonClasses.SendError("Material Inspection", "chkFormToAll_CheckedChanged", ex.Message.ToString());
}
}
protected void dgBatch_RowEditing(object sender, GridViewEditEventArgs e)
{
try
{
if (CommonClasses.ValidRights(int.Parse(right.Substring(2, 1)), this, "For Modify"))
{
string ce_code = ((Label)(dgBatch.Rows[e.NewEditIndex].FindControl("lblTSM_CODE"))).Text;
string type = "MODIFY";
Response.Redirect("~/Transactions/ADD/TinterSheet.aspx?c_name=" + type + "&ce_code=" + ce_code, false);
}
else
{
PanelMsg.Visible = true;
lblmsg.Text = "You have no rights to modify";
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
return;
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Tinter Sheet", "dgBatch_RowEditing", Ex.Message);
}
}
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);
}
}
bool CheckValid()
{
bool flag = false;
try
{
if (txtQuery.Text == "")
{
flag = false;
}
else
{
flag = true;
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Paid Holidays", "CheckValid", Ex.Message);
}
return(flag);
}
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
{
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);
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
try
{
if (CommonClasses.ValidRights(int.Parse(right.Substring(2, 1)), this, "For Update"))
{
string user_code = ((Label)(dgPoTypeMaster.Rows[e.NewEditIndex].FindControl("lblPO_T_CODE"))).Text;
string type = "MODIFY";
Response.Redirect("~/Masters/ADD/PoTypeMaster.aspx?c_name=" + type + "&u_code=" + user_code, false);
}
else
{
PanelMsg.Visible = true;
lblmsg.Text = "You Have No Rights To Modify";
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
}
}
catch (Exception exc)
{
CommonClasses.SendError("Po Type Master", "GridView1_RowEditing", exc.Message);
}
}
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();
}
}
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);
}
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);
}
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);
}
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 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);
}
}
protected void btnAddNew_Click(object sender, EventArgs e)
{
try
{
if (CommonClasses.ValidRights(int.Parse(right.Substring(3, 1)), this, "For Add"))
{
string type = "INSERT";
Response.Redirect("~/Transactions/ADD/AnnualMaintainceContract.aspx?c_name=" + type, false);
}
else
{
PanelMsg.Visible = true;
lblmsg.Text = "You Have No Rights To Add";
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
return;
}
}
catch (Exception Ex)
{
CommonClasses.SendError("AMC Transaction", "btnAddNew_Click", Ex.Message);
}
}
void Awake()
{
if(common == null){
DontDestroyOnLoad(gameObject);
common = this;
} else {
Destroy(gameObject);
}
}
// Use this for initialization
void OnEnable()
{
//handler = GameHandler.handler;
Debug.Log(target);
controller = GetComponent<CharacterController>();
body = target.GetComponent<Body>();
common = CommonClasses.common;
if(targetAI == targetAIs.Self){
target = tower.gameObject;
}
tombName = gameObject.name;
tombName = tombName.Remove(tombName.Length - 7);
Debug.Log("Starting "+tombName);
}
