private void InsUpdDelKnittingSubCategory(char Event, int id)
{
var msg = "";
if (Event == 'I' || Event == 'U')
{
var objKnitting = new KnittingSubCategory(id, int.Parse(ddlCategory.SelectedValue), "", txtSubCategoryName.Text);
msg = BL_Knitting_SubCategory.InsUpdDelKnittingSubCategory(Event, objKnitting, out id);
}
else
{
var objKnitting = new KnittingSubCategory(id, int.Parse(ddlCategory.SelectedValue), "", "");
msg = BL_Knitting_SubCategory.InsUpdDelKnittingSubCategory(Event, objKnitting, out id);
}
if (DatabaseMessage.ContainMessage(msg))
{
_msgbox.ShowSuccess(msg);
}
else
{
_msgbox.ShowWarning(msg);
}
FillGridview();
ClearAll();
}
public static List <KnittingSubCategory> GetKnittingSubCategory(int Event, int id, string code, string code1)
{
var lst = new List <KnittingSubCategory>();
var dt = DlKnittingSubCategory.GetKnittingSubCategory(Event, id, code, code1);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
var obj = new KnittingSubCategory(Convert.ToInt32(dr["Id"]), Convert.ToInt32(dr["Category_Id"]), dr["Category"].ToString(), dr["SubCategory"].ToString());
lst.Add(obj);
}
}
return(lst);
}
public static string InsUpdDelKnittingSubCategory(char Event, KnittingSubCategory obj, out int returnId)
{
returnId = 0;
try
{
var cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "USP_IUD_Knitting_Sub_Category";
cmd.Connection = DL_CCommon.ConnectionForCommonDb();
cmd.Parameters.AddWithValue("@EVENT", Event);
cmd.Parameters.AddWithValue("@ID", obj.Id);
cmd.Parameters.AddWithValue("@CategoryId", obj.CategoryId);
cmd.Parameters.AddWithValue("@SubCategory", obj.SubCategory);
var outparameter = new SqlParameter("@MSG", SqlDbType.NVarChar, 200)
{
Direction = ParameterDirection.Output
};
cmd.Parameters.Add(outparameter);
var outId = new SqlParameter("@RETURNOUTID", SqlDbType.NVarChar, 100)
{
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 static string InsUpdDelKnittingSubCategory(char Event, KnittingSubCategory obj, out int id)
{
id = 0;
return(DlKnittingSubCategory.InsUpdDelKnittingSubCategory(Event, obj, out id));
}
