protected void SaveLookupValues()
{
try
{
lblerr.Text = "";
LookupValue_Entity objEntity = new LookupValue_Entity();
objEntity.Lookup_Catg_ID = Convert.ToInt32(DDL_LOOKUP_CATG_ID.SelectedValue);
objEntity.ValueText = TXT_VALUETEXT.Text;
objEntity.DisplayText = TXT_DISPLAYTEXT.Text;
objEntity.FlexField1_Name = TXT_FLEXFIELD1.Text;
objEntity.FlexField2_Name = TXT_FLEXFIELD2.Text;
objEntity.FlexField3_Name = TXT_FLEXFIELD3.Text;
objEntity.FlexField4_Name = TXT_FLEXFIELD4.Text;
objEntity.FlexField5_Name = TXT_FLEXFIELD5.Text;
objEntity.IsActive = CHK_ROWACTIVE.Checked;
objEntity.Row_ID = 0;
objEntity.CreatedBy = 1;
lblerr.Text = cls_Lookup_BAL.Save_LookupValues_BAL(objEntity);
//if (cls_Lookup_BAL.Save_LookupValues_BAL(objEntity) > 0) lblerr.Text = "Record saved";
//else lblerr.Text = "Failed to save the record";
GetLookupValues();
}
catch (Exception ex)
{
lblerr.Text = "Save lookup values" + ex.Message;
}
}
public string Save_LookupValues_DAL(LookupValue_Entity objEntity)
{
try
{
SqlParameter[] p = new SqlParameter[11];
p[0] = new SqlParameter("@Lookup_Catg_ID", objEntity.Lookup_Catg_ID);
p[1] = new SqlParameter("@ValueText", objEntity.DisplayText);
p[2] = new SqlParameter("@DisplayText", objEntity.DisplayText);
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("@isActive", objEntity.IsActive);
p[10] = new SqlParameter("@Row_ID", objEntity.Row_ID);
objDB.ExecuteProc("[QAACHE].[Insert_LookupValues]", p, ref errmsg);
return((errmsg != "") ? errmsg : "Record Saved");
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static string Save_LookupValues_BAL(LookupValue_Entity objEntity)
{
try
{
cls_Lookup_DAL objdal = new cls_Lookup_DAL();
return(objdal.Save_LookupValues_DAL(objEntity));
}
catch (Exception ex)
{
//return 0;
throw new Exception(ex.Message);
}
}
protected void dlentry_ItemCommand(object source, DataListCommandEventArgs e)
{
try
{
lblerr.Text = "";
if (e.CommandName == "EDIT")
{
dlentry.EditItemIndex = e.Item.ItemIndex;
GetLookupValues();
}
if (e.CommandName == "CANCEL")
{
dlentry.EditItemIndex = -1;
GetLookupValues();
}
if (e.CommandName == "UPDATE")
{
if (((DropDownList)e.Item.FindControl("DDL_LOOKUP_CATG_ID_1")).Text == "-Select-" || ((TextBox)e.Item.FindControl("TXT_DISPLAYTEXT_1")).Text == "")
{
lblerr.Text = "Fields marked with * can not be blank";
}
else
{
LookupValue_Entity objEntity = new LookupValue_Entity();
objEntity.Row_ID = Convert.ToInt32(((HiddenField)e.Item.FindControl("hf_rowID")).Value);
objEntity.Lookup_Catg_ID = Convert.ToInt32(((DropDownList)e.Item.FindControl("DDL_LOOKUP_CATG_ID_1")).Text);
objEntity.ValueText = ((TextBox)e.Item.FindControl("TXT_DISPLAYTEXT_1")).Text.ToString();
objEntity.DisplayText = ((TextBox)e.Item.FindControl("TXT_DISPLAYTEXT_1")).Text.ToString();
objEntity.FlexField1_Name = ((TextBox)e.Item.FindControl("TXT_FLEXFIELD1_1")).Text.ToString();
objEntity.FlexField2_Name = ((TextBox)e.Item.FindControl("TXT_FLEXFIELD2_1")).Text.ToString();
objEntity.FlexField3_Name = ((TextBox)e.Item.FindControl("TXT_FLEXFIELD3_1")).Text.ToString();
objEntity.FlexField4_Name = ((TextBox)e.Item.FindControl("TXT_FLEXFIELD4_1")).Text.ToString();
objEntity.FlexField5_Name = ((TextBox)e.Item.FindControl("TXT_FLEXFIELD5_1")).Text.ToString();
objEntity.CreatedBy = 1;
objEntity.IsActive = Convert.ToBoolean(((CheckBox)e.Item.FindControl("CHK_ROWACTIVE_1")).Checked);
lblerr.Text = cls_Lookup_BAL.Save_LookupValues_BAL(objEntity);
GetLookupValues();
}
}
}
catch (Exception ex)
{
lblerr.Text = "Item command - " + ex.Message;
}
}
