public void BindBrand(Int64 bid)
{
brandMaster objcategory = (new Cls_brand_b().SelectById(bid));
if (objcategory != null)
{
//ddlBank.SelectedValue = objcategory.bankid.ToString();
txtBrandName.Text = objcategory.brandName;
}
}
public brandMaster SelectById(Int64 cid)
{
SqlDataAdapter da;
DataSet ds = new DataSet();
brandMaster objcategory = new brandMaster();
try
{
SqlCommand cmd = new SqlCommand
{
CommandText = "brand_SelectById",
CommandType = CommandType.StoredProcedure,
Connection = ConnectionString
};
cmd.Parameters.AddWithValue("@bid", cid);
ConnectionString.Open();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
{
objcategory.bid = Convert.ToInt64(ds.Tables[0].Rows[0]["bid"]);
objcategory.brandName = Convert.ToString(ds.Tables[0].Rows[0]["brandName"]);
}
}
}
}
}
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(null);
}
finally
{
ConnectionString.Close();
}
return(objcategory);
}
//protected override void Render(HtmlTextWriter writer)
//{
// string validatorOverrideScripts = "<script src=\"" + Page.ResolveUrl("~") + "js/validators.js\" type=\"text/javascript\"></script>";
// this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ValidatorOverrideScripts", validatorOverrideScripts, false);
// base.Render(writer);
//}
protected void btnSave_Click(object sender, EventArgs e)
{
Int64 Result = 0;
brandMaster objcategory = new brandMaster();
objcategory.brandName = txtBrandName.Text.Trim();
if (Request.QueryString["id"] != null)
{
objcategory.bid = Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true));
Result = (new Cls_brand_b().Update(objcategory));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/manageBrand.aspx?mode=u"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Brand Not Updated";
BindBrand(Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true)));
}
}
else
{
Result = (new Cls_brand_b().Insert(objcategory));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/manageBrand.aspx?mode=i"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Brand Saved";
}
}
}
public Int64 Insert(brandMaster objcategory)
{
Int64 result = 0;
try
{
SqlCommand cmd = new SqlCommand
{
CommandText = "brand_Insert",
CommandType = CommandType.StoredProcedure,
Connection = ConnectionString
};
SqlParameter param = new SqlParameter
{
ParameterName = "@bid",
Value = objcategory.bid,
SqlDbType = SqlDbType.BigInt,
Direction = ParameterDirection.InputOutput
};
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@brandName", objcategory.brandName);
ConnectionString.Open();
cmd.ExecuteNonQuery();
result = Convert.ToInt64(param.Value);
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(result);
}
finally
{
ConnectionString.Close();
}
return(result);
}
