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