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