public Int64 Update(maincategory objcategory)
{
Int64 result = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "maincategory_Update";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
SqlParameter param = new SqlParameter();
param.ParameterName = "@id";
param.Value = objcategory.id;
param.SqlDbType = SqlDbType.BigInt;
param.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@name", objcategory.name);
cmd.Parameters.AddWithValue("@imagename", objcategory.imagename);
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);
}
//public DataTable category_WSSelectAll()
//{
// DataSet ds = new DataSet();
// SqlDataAdapter da;
// try
// {
// SqlCommand cmd = new SqlCommand();
// cmd.CommandText = "category_WSSelectAll";
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Connection = ConnectionString;
// ConnectionString.Open();
// da = new SqlDataAdapter(cmd);
// da.Fill(ds);
// }
// catch (Exception ex)
// {
// ErrHandler.writeError(ex.Message, ex.StackTrace);
// return null;
// }
// finally
// {
// ConnectionString.Close();
// }
// return ds.Tables[0];
//}
public maincategory SelectById(Int64 cid)
{
SqlDataAdapter da;
DataSet ds = new DataSet();
maincategory objcategory = new maincategory();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "maincategory_SelectById";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
cmd.Parameters.AddWithValue("@id", 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.id = Convert.ToInt64(ds.Tables[0].Rows[0]["id"]);
objcategory.name = Convert.ToString(ds.Tables[0].Rows[0]["name"]);
objcategory.imagename = Convert.ToString(ds.Tables[0].Rows[0]["imagename"]);
}
}
}
}
}
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(null);
}
finally
{
ConnectionString.Close();
}
return(objcategory);
}
protected void btnSave_Click(object sender, EventArgs e)
{
Int64 Result = 0;
maincategory objcategory = new maincategory();
objcategory.name = txtCategoryName.Text.Trim();
if (ViewState["fileName"] != null)
{
objcategory.imagename = ViewState["fileName"].ToString();
}
if (Request.QueryString["id"] != null)
{
objcategory.id = Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true));
Result = (new Cls_maincategory_b().Update(objcategory));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/managemaincategory.aspx?mode=u"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Category Not Updated";
BindCategory(Convert.ToInt64(ocommon.Decrypt(Request.QueryString["id"].ToString(), true)));
}
}
else
{
Result = (new Cls_maincategory_b().Insert(objcategory));
if (Result > 0)
{
Clear();
Response.Redirect(Page.ResolveUrl("~/managemaincategory.aspx?mode=i"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Category Not Inserted";
}
}
}
public void BindCategory(Int64 CategoryId)
{
maincategory objcategory = (new Cls_maincategory_b().SelectById(CategoryId));
if (objcategory != null)
{
//ddlBank.SelectedValue = objcategory.bankid.ToString();
txtCategoryName.Text = objcategory.name;
if (!string.IsNullOrEmpty(objcategory.imagename))
{
imgCategory.Visible = true;
ViewState["fileName"] = objcategory.imagename;
imgCategory.ImageUrl = categoryFrontPath + objcategory.imagename;
btnImageUpload.Visible = false;
btnRemove.Visible = true;
}
else
{
btnImageUpload.Visible = true;
}
}
}
