private void InsUpdDelIncomeExp(char Event, int Id)
{
try
{
BlIncomeExp objbl = new BlIncomeExp();
PL_IncomeExp obj = new PL_IncomeExp();
obj.IE_ID = Id;
obj.EVENT = Event;
if (Event == 'D')
{
}
else
{
obj.IE_Code = txtParticularcode.Text;
obj.IE = txtParticular.Text;
obj.IE_ParentID = int.Parse(tv.SelectedNode.Value);
obj.IE_Primary = chkPrimary.Checked;
//obj.Ie_Child = ddlUnder.SelectedValue;
obj.IsNeeded = chkIsNeeded.Checked;
}
string msg = objbl.InsUpdDelIncomeExp(obj, out Id);
if (msg == "Record Inserted Successfully" || msg == "Record Updated Successfully" || msg == "Record Deleted Successfully")
{
msgbox.ShowSuccess(msg);
BuildTree(Convert.ToInt32(hfValue.Value));
Clear();
}
else
{
msgbox.ShowWarning(msg);
}
}
catch (Exception ex)
{
msgbox.ShowWarning(ex.Message);
}
}
public static string InsUpdDelIncomeExp(PL_IncomeExp obj, out int ReturnId)
{
ReturnId = 0;
try
{
var cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "USP_IUD_IncomeExp";
cmd.Connection = DL_CCommon.ConnectionForCommonDb();
cmd.Parameters.AddWithValue("@Event", obj.EVENT);
cmd.Parameters.AddWithValue("@IE_ID", obj.IE_ID);
cmd.Parameters.AddWithValue("@IE_Code", obj.IE_Code);
cmd.Parameters.AddWithValue("@IE", obj.IE);
cmd.Parameters.AddWithValue("@IE_ParentID", obj.IE_ParentID);
cmd.Parameters.AddWithValue("@IE_Primary", obj.IE_Primary);
cmd.Parameters.AddWithValue("@Ie_Child", obj.Ie_Child);
cmd.Parameters.AddWithValue("@IsNeeded", obj.IsNeeded);
var outparameter = new SqlParameter("@MSG", SqlDbType.NVarChar, 200);
outparameter.Direction = ParameterDirection.Output;
cmd.Parameters.Add(outparameter);
var OutId = new SqlParameter("@RETURNOUTID", SqlDbType.NVarChar, 100);
OutId.Direction = ParameterDirection.Output;
cmd.Parameters.Add(OutId);
cmd.ExecuteNonQuery();
var msg = cmd.Parameters[outparameter.ParameterName].Value;
ReturnId = Convert.ToInt32(cmd.Parameters[OutId.ParameterName].Value);
return(Convert.ToString(msg));
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
finally
{
DL_CCommon.ConnectionForCommonDb().Close();
}
}
public string InsUpdDelIncomeExp(PL_IncomeExp obj, out int Id)
{
return(DlIncomeExp.InsUpdDelIncomeExp(obj, out Id));
}
