public int insertCatagoryDA(BusinessEntitiesBS.Catagory_Entities.catagoryObj catObjDa)
{
try
{
SqlParameter[] sqlParams = new SqlParameter[3];
//Catgory parameters
sqlParams[0] = new SqlParameter("@catagoryName", catObjDa.catagoryName);
sqlParams[1] = new SqlParameter("@CatagoryDescription", catObjDa.catagoryDesc);
sqlParams[2] = new SqlParameter("@catStatus", catObjDa.catagoryStatus);
DataTable idcDt = DBHelper.ExecuteDataset(DBCommon.ConnectionString, "USP_INSERT_CATAGORY", sqlParams).Tables[0];
int idCat = Convert.ToInt32(idcDt.Rows[0].ItemArray[0].ToString());
if (idcDt.Rows.Count > 0)
{
return(idCat);
}
else
{
return(-1);
}
}
catch (SqlException exc)
{
return(-1);
throw exc;
}
}
public int insertCatagory(BusinessEntitiesBS.Catagory_Entities.catagoryObj catObj)
{
try
{
IAdminDA catInsert = new DataAccessBS.AdminClasses.AdminDA();
int catChk = catInsert.insertCatagoryDA(catObj);
return(catChk);
}
catch
{
return(-1);
}
}
protected void CatagoryBtn_Click(object sender, EventArgs e)
{
string catName = CatagoryTxt.Text;
string catDesc = catDescTxt.InnerText.ToString();
bool catStatus = catStatusCb.Checked;
BusinessEntitiesBS.Catagory_Entities.catagoryObj catObj = new BusinessEntitiesBS.Catagory_Entities.catagoryObj();
catObj.catagoryName = catName;
catObj.catagoryDesc = catDesc;
catObj.catagoryStatus = catStatus;
try
{
IAdmin catInsert = new AdminItems();
int insertCatChk = catInsert.insertCatagory(catObj);
if (insertCatChk != -1)
{
string NewDir = Server.MapPath("~/ItemImages/" + insertCatChk);
try
{
// Check if directory exists
if (!Directory.Exists(NewDir))
{
// Create the directory.
Directory.CreateDirectory(NewDir);
catMsgLbl.Text = HardCodedValues.BuddaResource.CatogoryAdd;
getcatgs();
}
}
catch (IOException _ex)
{
catMsgLbl.Text = HardCodedValues.BuddaResource.FloderError + _ex.Message;
}
}
else
{
catMsgLbl.Text = HardCodedValues.BuddaResource.CatogoryNotAdded;
catMsgLbl.ForeColor = System.Drawing.Color.Red;
}
ClearCache();
}
catch (Exception exp)
{
//throw exp;
catMsgLbl.Text = HardCodedValues.BuddaResource.ConnectionError + exp.Message;
catMsgLbl.ForeColor = System.Drawing.Color.Red;
}
}
protected void CatagoryBtn_Click(object sender, EventArgs e)
{
string catName = CatagoryTxt.Text;
string catDesc = catDescTxt.InnerText.ToString();
bool catStatus = catStatusCb.Checked;
BusinessEntitiesBS.Catagory_Entities.catagoryObj catObj = new BusinessEntitiesBS.Catagory_Entities.catagoryObj();
catObj.catagoryName = catName;
catObj.catagoryDesc = catDesc;
catObj.catagoryStatus = catStatus;
try
{
IAdmin catInsert = new AdminItems();
int insertCatChk = catInsert.insertCatagory(catObj);
if (insertCatChk != -1)
{
string NewDir = Server.MapPath("~/ItemImages/" + insertCatChk);
try
{
// Check if directory exists
if (!Directory.Exists(NewDir))
{
// Create the directory.
Directory.CreateDirectory(NewDir);
catMsgLbl.Text = "Catagory inserted";
}
}
catch (IOException _ex)
{
catMsgLbl.Text = "Error: Floder" + _ex.Message;
}
}
else
{
catMsgLbl.Text = "Catagory not inserted";
catMsgLbl.ForeColor = System.Drawing.Color.Red;
}
}
catch (Exception exp)
{
//throw exp;
catMsgLbl.Text = "Unable to connect" + exp.Message;
catMsgLbl.ForeColor = System.Drawing.Color.Red;
}
}
protected void CatagoryBtn_Click(object sender, EventArgs e)
{
string catName = CatagoryTxt.Text;
string catDesc = catDescTxt.InnerText.ToString();
bool catStatus = catStatusCb.Checked;
BusinessEntitiesBS.Catagory_Entities.catagoryObj catObj = new BusinessEntitiesBS.Catagory_Entities.catagoryObj();
catObj.catagoryName = catName;
catObj.catagoryDesc = catDesc;
catObj.catagoryStatus = catStatus;
try
{
IAdmin catInsert = new AdminItems();
int insertCatChk = catInsert.insertCatagory(catObj);
if (insertCatChk != -1)
{
string NewDir = Server.MapPath("~/ItemImages/" + insertCatChk);
try
{
// Check if directory exists
if (!Directory.Exists(NewDir))
{
// Create the directory.
Directory.CreateDirectory(NewDir);
catMsgLbl.Text = "Catagory inserted";
}
}
catch (IOException _ex)
{
catMsgLbl.Text = "Error: Floder" + _ex.Message;
}
}
else
{
catMsgLbl.Text = "Catagory not inserted";
catMsgLbl.ForeColor = System.Drawing.Color.Red;
}
}
catch (Exception exp)
{
//throw exp;
catMsgLbl.Text = "Unable to connect" + exp.Message;
catMsgLbl.ForeColor = System.Drawing.Color.Red;
}
}
protected void CatagoryBtn_Click(object sender, EventArgs e)
{
string catName = CatagoryTxt.Text;
string catDesc = catDescTxt.InnerText.ToString();
bool catStatus = catStatusCb.Checked;
BusinessEntitiesBS.Catagory_Entities.catagoryObj catObj = new BusinessEntitiesBS.Catagory_Entities.catagoryObj();
catObj.catagoryName = catName;
catObj.catagoryDesc = catDesc;
catObj.catagoryStatus = catStatus;
try
{
IAdmin catInsert = new AdminItems();
int insertCatChk = catInsert.insertCatagory(catObj);
if (insertCatChk != -1)
{
string NewDir = Server.MapPath("~/ItemImages/" + insertCatChk);
try
{
// Check if directory exists
if (!Directory.Exists(NewDir))
{
// Create the directory.
Directory.CreateDirectory(NewDir);
catMsgLbl.Text = HardCodedValues.BuddaResource.CatogoryAdd;
getcatgs();
}
}
catch (IOException _ex)
{
catMsgLbl.Text = HardCodedValues.BuddaResource.FloderError + _ex.Message;
}
}
else
{
catMsgLbl.Text = HardCodedValues.BuddaResource.CatogoryNotAdded;
catMsgLbl.ForeColor = System.Drawing.Color.Red;
}
ClearCache();
}
catch (Exception exp)
{
//throw exp;
catMsgLbl.Text = HardCodedValues.BuddaResource.ConnectionError + exp.Message;
catMsgLbl.ForeColor = System.Drawing.Color.Red;
}
}
