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; } }