private void InsUpdDelLa(char Event, int Id)
{
try
{
BlLa objbl = new BlLa();
PL_LA obj = new PL_LA();
obj.LA_ID = Id;
obj.EVENT = Event;
if (Event == 'D')
{
}
else
{
obj.LA_Code = txtParticularcode.Text;
obj.LA = txtParticular.Text;
obj.LA_ParentID = int.Parse(tv.SelectedNode.Value);
obj.LA_Primary = chkPrimary.Checked;
//obj.LA_Child = ddlUnder.SelectedValue;
obj.IsNeeded = chkIsNeeded.Checked;
//obj.p_headerid = int.Parse(ddlPearls.SelectedValue);
}
string msg = objbl.InsUpdDelLa(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 InsUpdDelLA(PL_LA obj, out int ReturnId)
{
ReturnId = 0;
try
{
var cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "USP_IUD_LA";
cmd.Connection = DL_CCommon.ConnectionForCommonDb();
cmd.Parameters.AddWithValue("@Event", obj.EVENT);
cmd.Parameters.AddWithValue("@LA_ID", obj.LA_ID);
cmd.Parameters.AddWithValue("@LA_Code", obj.LA_Code);
cmd.Parameters.AddWithValue("@LA", obj.LA);
cmd.Parameters.AddWithValue("@LA_ParentID", obj.LA_ParentID);
cmd.Parameters.AddWithValue("@LA_Primary", obj.LA_Primary);
cmd.Parameters.AddWithValue("@LA_Child", obj.LA_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 InsUpdDelLa(PL_LA obj, out int Id)
{
return(DlLa.InsUpdDelLA(obj, out Id));
}
