private void SaveLookupCategories() { try { LookupCategory_Entity objEntity = new LookupCategory_Entity(); objEntity.Lookup_Catg_Name = TXT_LOOKUP_CATG_NAME.Text; objEntity.Catg_Description = TXT_CATG_DESCRIPTION.Text; objEntity.RefClause = TXT_REF_CLAUSE.Text; objEntity.FlexField1_Name = TXT_FLEXFIELD1_NAME.Text; objEntity.FlexField2_Name = TXT_FLEXFIELD2_NAME.Text; objEntity.FlexField3_Name = TXT_FLEXFIELD3_NAME.Text; objEntity.FlexField4_Name = TXT_FLEXFIELD4_NAME.Text; objEntity.FlexField5_Name = TXT_FLEXFIELD5_NAME.Text; objEntity.CreatedBy = 1; objEntity.SORTEXPRESSION = DDL_SORTEXPRESSION.Text + " " + ddl_direction.Text; if (cls_Lookup_BAL.Save_LookupCategiries_BAL(objEntity) > 0) { lblerr.Text = "Record saved"; } else { lblerr.Text = "Failed to save the record"; } GetLookupCategories(); } catch (Exception ex) { lblerr.Text = "Save - " + ex.Message; } }
public static string Save_LookupCategiries_BAL(LookupCategory_Entity objEntity) { try { cls_Lookup_DAL objdal = new cls_Lookup_DAL(); return(objdal.Save_LookupCategiries_DAL(objEntity)); } catch (Exception ex) { throw new Exception(ex.Message); } }
protected void dlentry_ItemCommand(object source, DataListCommandEventArgs e) { try { if (e.CommandName == "EDIT") { dlentry.EditItemIndex = e.Item.ItemIndex; GetLookupCategories(); } if (e.CommandName == "CANCEL") { dlentry.EditItemIndex = -1; GetLookupCategories(); } if (e.CommandName == "UPDATE") { if (((TextBox)e.Item.FindControl("TXT_LOOKUP_CATG_NAME_1")).Text == "" || ((TextBox)e.Item.FindControl("TXT_CATG_DESCRIPTION_1")).Text == "") { lblerr.Text = "Fields marked with * can not be blank"; } else { string sortExp = ((DropDownList)e.Item.FindControl("DDL_SORTEXPRESSION")).SelectedItem.ToString() + " " + ((DropDownList)e.Item.FindControl("ddl_direction")).SelectedItem.ToString(); LookupCategory_Entity objEntity = new LookupCategory_Entity(); objEntity.Lookup_Catg_ID = Convert.ToInt32(((HiddenField)e.Item.FindControl("hf_nlookupcatid")).Value); objEntity.Lookup_Catg_Name = ((TextBox)e.Item.FindControl("TXT_LOOKUP_CATG_NAME_1")).Text.ToString(); objEntity.Catg_Description = ((TextBox)e.Item.FindControl("TXT_CATG_DESCRIPTION_1")).Text.ToString(); objEntity.RefClause = ((TextBox)e.Item.FindControl("TXT_REF_CLAUSE_1")).Text.ToString(); objEntity.FlexField1_Name = ((TextBox)e.Item.FindControl("TXT_FLEXFIELD1_NAME_1")).Text.ToString(); objEntity.FlexField2_Name = ((TextBox)e.Item.FindControl("TXT_FLEXFIELD2_NAME_1")).Text.ToString(); objEntity.FlexField3_Name = ((TextBox)e.Item.FindControl("TXT_FLEXFIELD3_NAME_1")).Text.ToString(); objEntity.FlexField4_Name = ((TextBox)e.Item.FindControl("TXT_FLEXFIELD4_NAME_1")).Text.ToString(); objEntity.FlexField5_Name = ((TextBox)e.Item.FindControl("TXT_FLEXFIELD5_NAME_1")).Text.ToString(); objEntity.CreatedBy = 1; objEntity.SORTEXPRESSION = sortExp; lblerr.Text = cls_Lookup_BAL.Save_LookupCategiries_BAL(objEntity); //if (cls_Lookup_BAL.Save_LookupCategiries_BAL(objEntity) > 0) lblerr.Text = "Record saved"; //else lblerr.Text = "Failed to save the record"; GetLookupCategories(); } } } catch (Exception ex) { lblerr.Text = "Item command - " + ex.Message; } }
public string Save_LookupCategiries_DAL(LookupCategory_Entity objEntity) { try { SqlParameter[] p = new SqlParameter[11]; p[0] = new SqlParameter("@Lookup_Catg_Name", objEntity.Lookup_Catg_Name); p[1] = new SqlParameter("@Catg_Description", objEntity.Catg_Description); p[2] = new SqlParameter("@RefClause", objEntity.RefClause); p[3] = new SqlParameter("@FlexField1_Name", objEntity.FlexField1_Name); p[4] = new SqlParameter("@FlexField2_Name", objEntity.FlexField2_Name); p[5] = new SqlParameter("@FlexField3_Name", objEntity.FlexField3_Name); p[6] = new SqlParameter("@FlexField4_Name", objEntity.FlexField4_Name); p[7] = new SqlParameter("@FlexField5_Name", objEntity.FlexField5_Name); p[8] = new SqlParameter("@CREATEDBY", objEntity.CreatedBy); p[9] = new SqlParameter("@SORTEXPRESSION", objEntity.SORTEXPRESSION); p[10] = new SqlParameter("@Lookup_Catg_ID", objEntity.Lookup_Catg_ID); objDB.ExecuteProc("[QAACHE].[Insert_LookupCategory]", p, ref errmsg); return((errmsg != "") ? errmsg : "Record Saved"); } catch (Exception ex) { throw new Exception(ex.Message + "-" + errmsg); } }