protected void dgCurrancyMaster_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
if (CommonClasses.ValidRights(int.Parse(right.Substring(4, 1)), this, "For Delete"))
{
if (!ModifyLog(((Label)(dgCurrancyMaster.Rows[e.RowIndex].FindControl("lblC_Code"))).Text))
{
Bl_CrrancyMaster = new CurrancyMaster_BL();
string Curr_Code = ((Label)(dgCurrancyMaster.Rows[e.RowIndex].FindControl("lblC_Code"))).Text;
//string Curr_Name = ((Label)(dgCurrancyMaster.Rows[e.RowIndex].FindControl("lblC_CURR_NAME"))).Text;
Bl_CrrancyMaster.CURR_CODE = Convert.ToInt32(Curr_Code);
if (CommonClasses.CheckUsedInTran("INVOICE_MASTER", "INM_CURR_CODE", "AND ES_DELETE=0", Curr_Code))
{
//ShowMessage("#Avisos", "You cant delete this record it has used in Components", CommonClasses.MSG_Warning);
PanelMsg.Visible = true;
lblmsg.Text = "You can't delete this record it has used in Invoice";
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
}
else if (CommonClasses.CheckUsedInTran("SUPP_PO_MASTER", "SPOM_CURR_CODE", "AND ES_DELETE=0", Curr_Code))
{
PanelMsg.Visible = true;
lblmsg.Text = "You can't delete this record it has used in Purchase Order";
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
}
else
{
bool flag = Bl_CrrancyMaster.Delete();
if (flag == true)
{
CommonClasses.WriteLog("Currancy Master", "Delete", "Currancy Master", Curr_Code, Convert.ToInt32(Curr_Code), Convert.ToInt32(Session["CompanyId"]), Convert.ToInt32(Session["CompanyCode"]), (Session["Username"].ToString()), Convert.ToInt32(Session["UserCode"]));
//ShowMessage("#Avisos", CommonClasses.strRegDelSucesso, CommonClasses.MSG_Erro);
PanelMsg.Visible = true;
lblmsg.Text = "Record Deleted Successfully";
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
}
}
}
LoadCurrancy();
}
else
{
PanelMsg.Visible = true;
lblmsg.Text = "You Have No Rights To Delete";
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Currency Master-View", "dgCurrancyMaster_RowDeleting", Ex.Message);
}
}
private void LoadCurrancy()
{
try
{
Bl_CrrancyMaster = new CurrancyMaster_BL();
Bl_CrrancyMaster.CURR_CM_COMP_ID = Convert.ToInt32(Session["CompanyId"]);
// Bl_CrrancyMaster.FillGrid(dgCurrancyMaster);
dt = CommonClasses.Execute("Select COUNTRY_NAME,CURR_NAME,CURR_CODE,CURR_SHORT_NAME,CURR_DESC,CURR_RATE from CURRANCY_MASTER,COUNTRY_MASTER where CURR_CM_COMP_ID = '" + Convert.ToInt32(Session["CompanyId"]) + "' and CURRANCY_MASTER.ES_DELETE=0 and COUNTRY_MASTER.COUNTRY_CODE=CURRANCY_MASTER.CURR_COUNTRY_CODE Order by CURR_NAME ");
dgCurrancyMaster.DataSource = dt;
dgCurrancyMaster.DataBind();
}
catch (Exception Ex)
{
CommonClasses.SendError("Currancy Master-View", "LoadCurrancy", Ex.Message);
}
}
private void ViewRec(string str)
{
try
{
BL_CurrancyMaster = new CurrancyMaster_BL(mlCode);
// BL_CurrancyMaster.GetInfo();
dt5 = CommonClasses.Execute("Select * from CURRANCY_MASTER where CURR_CM_COMP_ID = '" + Convert.ToInt32(Session["CompanyId"]) + "' and ES_DELETE=0 and CURR_CODE=" + mlCode + "");
GetValues(str);
if (str == "MOD")
{
CommonClasses.SetModifyLock("ITEM_CATEGORY_MASTER", "MODIFY", "I_CAT_CODE", mlCode);
}
}
catch (Exception Ex)
{
CommonClasses.SendError("Item Category Master", "ViewRec", 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='13'");
right = dtRights.Rows.Count == 0 ? "00000000" : dtRights.Rows[0][0].ToString();
LoadCountry();
try
{
if (Request.QueryString[0].Equals("VIEW"))
{
BL_CurrancyMaster = new CurrancyMaster_BL();
mlCode = Convert.ToInt32(Request.QueryString[1].ToString());
ViewRec("VIEW");
}
else if (Request.QueryString[0].Equals("MODIFY"))
{
BL_CurrancyMaster = new CurrancyMaster_BL();
mlCode = Convert.ToInt32(Request.QueryString[1].ToString());
ViewRec("MOD");
}
ddlCountry.Focus();
}
catch (Exception ex)
{
CommonClasses.SendError("Currancy Master", "PageLoad", ex.Message);
}
}
}
}
bool SaveRec()
{
int Zero = 0;
bool result = false;
try
{
if (Request.QueryString[0].Equals("INSERT"))
{
if (txtCurrencyRate.Text == Zero.ToString())
{
ShowMessage("#Avisos", "Rate not be a 0 ", CommonClasses.MSG_Warning);
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
return(false);
}
else
{
}
BL_CurrancyMaster = new CurrancyMaster_BL();
if (Setvalues())
{
if (BL_CurrancyMaster.Save())
// dt5=CommonClasses.Execute("Select * from CURRANCY_MASTER where CURR_CM_COMP_ID = '" + Convert.ToInt32(Session["CompanyId"]) + "' and ES_DELETE=0 and CURR_NAME!='"+txtCurrancyName.Text+"' and CURR_COUNTRY_CODE='"+ddlCountry.SelectedValue+"' ");
{
string Code = CommonClasses.GetMaxId("Select Max(CURR_CODE) from CURRANCY_MASTER");
CommonClasses.WriteLog("Currency Master", "Save", "Item Category Master", BL_CurrancyMaster.CURR_NAME, Convert.ToInt32(Code), Convert.ToInt32(Session["CompanyId"]), Convert.ToInt32(Session["CompanyCode"]), (Session["Username"].ToString()), Convert.ToInt32(Session["UserCode"]));
result = true;
Response.Redirect("~/Admin/VIEW/ViewCurrancyMaster.aspx", false);
}
else
{
if (BL_CurrancyMaster.Msg != "")
{
ShowMessage("#Avisos", BL_CurrancyMaster.Msg.ToString(), CommonClasses.MSG_Warning);
BL_CurrancyMaster.Msg = "";
}
ddlCountry.Focus();
}
}
}
else if (Request.QueryString[0].Equals("MODIFY"))
{
BL_CurrancyMaster = new CurrancyMaster_BL(mlCode);
if (Setvalues())
{
if (BL_CurrancyMaster.Update())
{
CommonClasses.RemoveModifyLock("CURRANCY_MASTER", "MODIFY", "CURR_CODE", mlCode);
CommonClasses.WriteLog("Currancy Master", "Update", "Currancy Master", BL_CurrancyMaster.CURR_NAME, mlCode, Convert.ToInt32(Session["CompanyId"]), Convert.ToInt32(Session["CompanyCode"]), (Session["Username"].ToString()), Convert.ToInt32(Session["UserCode"]));
result = true;
Response.Redirect("~/Admin/VIEW/ViewCurrancyMaster.aspx", false);
}
else
{
if (BL_CurrancyMaster.Msg != "")
{
ShowMessage("#Avisos", BL_CurrancyMaster.Msg.ToString(), CommonClasses.MSG_Warning);
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage", "Showalert();", true);
BL_CurrancyMaster.Msg = "";
}
txtCurrancyName.Focus();
}
}
}
}
catch (Exception ex)
{
CommonClasses.SendError("Currency Master", "SaveRec", ex.Message);
}
return(result);
}
