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)); }