protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Delete"))
{
try
{
LinkButton LB = (LinkButton)e.CommandSource;
GridView GV=(GridView)sender;
GridViewRow GVRow = (GridViewRow)LB.Parent.Parent;
string PCCid = GV.DataKeys[GVRow.RowIndex]["Id_Petty_Cash_Category"].ToString();
HiddenField1.Value = PCCid.ToString();
core_petty_cash_category PCC=new core_petty_cash_category();
PCC.UpdateMethod(@"UPDATE `core_petty_cash_category`
SET
`Is_Active` = 1,
`Edited_Date` = now()
WHERE `Id_Petty_Cash_Category` = '" + Convert.ToInt32(HiddenField1.Value) + @"';");
//PCC.UpdateMethod(@"UPDATE core_petty_cash_category SET Is_Active='1',Edited_date=now() WHERE Id_Petty_Cash_Category='" + Convert.ToString(HiddenField1.Value) + @"';");
ScriptManager.RegisterStartupScript(this, GetType(), "delete", "showAlert('success');", true);
this.ClearFeilds();
this.loadDDL();
}
catch(Exception ex)
{
Exception E=ex;
}
}
}
private void InsertPCCDetails()
{
if (cmdSubmit.CommandName.ToLower() == "SAVE".ToLower())
{
core_petty_cash_category pccObj = new core_petty_cash_category();
core_petty_cash_category_Objects ObjPCC = new core_petty_cash_category_Objects();
ObjPCC.Petty_Cash_Category_Name = PCC_Name.Text;
ObjPCC.Petty_Cash_Category_Code = PCC_Code.Text;
ObjPCC.Id_Ledger_Account = Convert.ToInt32(ddlLedgerAccountType.SelectedValue);
ObjPCC.Created_Date = DateTime.Now;
pccObj.Insert(ObjPCC);
ScriptManager.RegisterStartupScript(this, GetType(), "insert", "showAlert('success');", true);
}
if (cmdSubmit.CommandName.ToLower() == "UPDATE".ToLower())
{
if (!((HiddenField1.Value) == null || (HiddenField1.Value) == ""))
{
var sc = new core_petty_cash_category();//System.Net.WebUtility.HtmlEncode()
sc.UpdateMethod(@"UPDATE `core_petty_cash_category`
SET
`Petty_Cash_Category_Name` = '" + PCC_Name.Text.Trim().Replace("'", "''") + @"',
`Petty_Cash_Category_Code` = '" + PCC_Code.Text.Trim().Replace("'", "''") + @"',
`Id_Ledger_Account` = '" + Convert.ToInt32(ddlLedgerAccountType.SelectedValue) + @"',
`Edited_Date` = now()
WHERE `Id_Petty_Cash_Category` = '" + Convert.ToInt32(HiddenField1.Value) + @"';");
ScriptManager.RegisterStartupScript(this, GetType(), "update", "showAlert('success');", true);
}
}
this.ClearFeilds();
loadGrid();
}
