/// <summary>
/// used to insert the products types
/// </summary>
/// <param name="mso_products"></param>
/// <returns></returns>
public int _insert_product_type_info(MySqlAsmObjs mso_products)
{
try
{
int result = 0;
{
MySqlCommand cmd = new MySqlCommand("pro_insert_product_type_info", acon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("@type_name", mso_products.Pr_type_Name));
cmd.Parameters.Add(new MySqlParameter("@type_SH_name", mso_products.Pr_type_SH_name));
cmd.Parameters.Add(new MySqlParameter("@pro_id", mso_products.Prfk_id));
cmd.Parameters.Add(new MySqlParameter("@creby", mso_products.Pr_type_created_by));
acon.Open();
result = cmd.ExecuteNonQuery();
acon.Close();
}
return(result);
}
catch (Exception)
{
throw;
}
finally
{
acon.Close();
}
}
/// <summary>
/// used to insert the 4 fileds in the brands table
/// </summary>
/// <param name="mso_products"></param>
/// <returns></returns>
public int _insert_brands_info(MySqlAsmObjs mso_products)
{
try
{
int result = 0;
{
MySqlCommand cmd = new MySqlCommand("pro_insert_brand_info", acon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("@br_name1", mso_products.Br_name));
cmd.Parameters.Add(new MySqlParameter("@br_pr_id1", mso_products.Pr_id));
cmd.Parameters.Add(new MySqlParameter("@br_prt_id1", mso_products.Prfk_id));
cmd.Parameters.Add(new MySqlParameter("@br_createdBy1", mso_products.Br_createdtime));
acon.Open();
result = cmd.ExecuteNonQuery();
acon.Close();
}
return(result);
}
catch (Exception)
{
throw;
}
finally
{
acon.Close();
}
}
/// <summary>
/// to insert the cartrige model
/// </summary>
/// <param name="mso_products"></param>
/// <returns></returns>
public int _insert_asset_cartridge(MySqlAsmObjs mso_products)
{
try
{
int result = 0;
{
MySqlCommand cmd = new MySqlCommand("pro_insert_asset_cartridge", acon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("@Catri_Model1", mso_products.Cat_Model));
cmd.Parameters.Add(new MySqlParameter("@catri_createdby1", mso_products.Cat_AssetcodeID));
acon.Open();
result = cmd.ExecuteNonQuery();
acon.Close();
}
return(result);
}
catch (Exception)
{
throw;
}
finally
{
acon.Close();
}
}
/// <summary>
/// this used to insert the Asset Codes
/// </summary>
/// <param name="mso_products"></param>
/// <returns></returns>
public int _insert_Asset_Code_info(MySqlAsmObjs mso_products)
{
try
{
int result = 0;
{
MySqlCommand cmd = new MySqlCommand("pro_insert_AssetCode", acon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("@AS_AssetCode1", mso_products.AS_AssetCode));
cmd.Parameters.Add(new MySqlParameter("@prtids", mso_products.Pr_type_id));
cmd.Parameters.Add(new MySqlParameter("@prid", mso_products.Prfk_id));
cmd.Parameters.Add(new MySqlParameter("@As_cre", mso_products.As_CreatedBy));
acon.Open();
result = cmd.ExecuteNonQuery();
acon.Close();
}
return(result);
}
catch (Exception)
{
throw;
}
finally
{
acon.Close();
}
}
/// <summary>
/// _insert_Asset_printer_info
/// </summary>
/// <param name="mso_products"></param>
/// <returns></returns>
public int _insert_Asset_printer_info(MySqlAsmObjs mso_products)
{
try
{
int result = 0;
{
MySqlCommand cmd = new MySqlCommand("Pro_insert_Asset_full_info", pcon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("@at_aseet_code_id1", mso_products.At_aseet_code_id));
cmd.Parameters.Add(new MySqlParameter("@at_Assetcode1", mso_products.At_Assetcode));
pcon.Open();
result = cmd.ExecuteNonQuery();
pcon.Close();
}
return(result);
}
catch (Exception)
{
throw;
}
finally
{
pcon.Close();
}
}
protected void ddl_Asset_product_type_ad_SelectedIndexChanged(object sender, EventArgs e)
{
MySqlAsmObjs obj = new MySqlAsmObjs();
obj.Pr_sh_name = ddl_Asset_product_type_ad.SelectedItem.Value;
MysqlAsMDBCS ABC = new MysqlAsMDBCS();
DataTable dt = ABC._load_Asset_Short_name(obj);
if (dt.Rows.Count > 0)
{
txt_assetNew_Number.Text = "KPCL/" + dt.Rows[0]["pr_type_sh_Name"].ToString() + "/";
}
}
/// <summary>
/// to insert the full Asset INformation
/// </summary>
/// <returns></returns>
///
public int _insert_Asset_full_info(MySqlAsmObjs mso_products)
{
try
{
int result = 0;
{
MySqlCommand cmd = new MySqlCommand("Pro_insert_Asset_full_info", acon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("@at_type1", mso_products.At_type_id));
cmd.Parameters.Add(new MySqlParameter("@at_subtype1", mso_products.At_subtype_id));
cmd.Parameters.Add(new MySqlParameter("@at_brandMake1", mso_products.At_brandMake_id));
cmd.Parameters.Add(new MySqlParameter("@at_model1", mso_products.At_model_id));
cmd.Parameters.Add(new MySqlParameter("@at_aseet_code_id1", mso_products.At_aseet_code_id));
cmd.Parameters.Add(new MySqlParameter("@at_Assetcode1", mso_products.At_Assetcode));
cmd.Parameters.Add(new MySqlParameter("@at_productNumber1", mso_products.At_productNumber));
cmd.Parameters.Add(new MySqlParameter("@at_purchaseNumber1", mso_products.At_purchaseNumber));
cmd.Parameters.Add(new MySqlParameter("@at_SerialNumber1", mso_products.At_SerialNumber));
cmd.Parameters.Add(new MySqlParameter("@at_voucherNumber1", mso_products.At_voucherNumber));
cmd.Parameters.Add(new MySqlParameter("@at_receivedDate1", mso_products.At_receivedDate));
cmd.Parameters.Add(new MySqlParameter("@at_wsd1", mso_products.At_wsd));
cmd.Parameters.Add(new MySqlParameter("@at_wed1", mso_products.At_wed));
cmd.Parameters.Add(new MySqlParameter("@at_cby1", mso_products.At_cby));
acon.Open();
result = cmd.ExecuteNonQuery();
acon.Close();
}
return(result);
}
catch (Exception)
{
throw;
}
finally
{
acon.Close();
}
}
public DataTable _load_Asset_models_byid(MySqlAsmObjs mys)
{
DataTable dt = new DataTable();
try
{
acon.Open();
MySqlCommand msc = new MySqlCommand("pro_view_model_byid", acon);
msc.Parameters.Add(new MySqlParameter("@mo_br_id1", mys.Mo_br_id));
msc.CommandType = CommandType.StoredProcedure;
MySqlDataAdapter da = new MySqlDataAdapter(msc);
da.Fill(dt);
}
catch
{
throw new Exception("who knows ahammed");
}
finally
{
acon.Close();
}
return(dt);
}
public DataTable _load_Asset_Short_name(MySqlAsmObjs mys)
{
DataTable dt = new DataTable();
try
{
acon.Open();
MySqlCommand msc = new MySqlCommand("pro_view_shortName", acon);
msc.Parameters.Add(new MySqlParameter("shname", mys.Pr_sh_name));
msc.CommandType = CommandType.StoredProcedure;
MySqlDataAdapter da = new MySqlDataAdapter(msc);
da.Fill(dt);
}
catch
{
throw new Exception("who knows ahammed");
}
finally
{
acon.Close();
}
return(dt);
}
//pro_view_brands_by_prptr_ids
public DataTable _load_Asset_brands_byprptrid(MySqlAsmObjs mys)
{
DataTable dt1 = new DataTable();
try
{
acon.Open();
MySqlCommand msc = new MySqlCommand("pro_view_brands_by_prptr_ids", acon);
msc.Parameters.Add(new MySqlParameter("prid", mys.Pr_id));
msc.Parameters.Add(new MySqlParameter("prtid", mys.Pr_type_id));
msc.CommandType = CommandType.StoredProcedure;
MySqlDataAdapter da = new MySqlDataAdapter(msc);
da.Fill(dt1);
}
catch
{
throw new Exception("who knows ahammed");
}
finally
{
acon.Close();
}
return(dt1);
}