public string Save_InputVariable_DAL(InputVariable_Entity objEntity, ref string errmsg)
{
try
{
DBConnect objDB = new DBConnect();
SqlParameter[] p = new SqlParameter[9];
p[0] = new SqlParameter("@ProcInitial", objEntity.ProcInitial);
p[1] = new SqlParameter("@LookupCatID", objEntity.LookupCatID);
p[2] = new SqlParameter("@VariableName", objEntity.VariableName);
p[3] = new SqlParameter("@DisplayName", objEntity.DisplayName);
p[4] = new SqlParameter("@ControlType", objEntity.ControlType);
//p[5] = new SqlParameter("@SeqNo", objEntity.SeqNo);
p[5] = new SqlParameter("@CREATEDBY", objEntity.CreatedBy);
p[6] = new SqlParameter("@isActive", objEntity.IsActive);
p[7] = new SqlParameter("@IsRequried", objEntity.IsRequried);
p[8] = new SqlParameter("@VarID", objEntity.VarID);
objDB.ExecuteProc("[QAACHE].[Insert_ProcInputVariables]", p, ref errmsg);
return((errmsg != "") ? errmsg : "Record Saved");
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
protected void SaveInputVariables()
{
try
{
InputVariable_Entity objEntity = new InputVariable_Entity();
objEntity.VarID = Convert.ToInt32(hf_vid.Value);
objEntity.LookupCatID = (txtLookupID.Text == "") ? 0 : Convert.ToInt32(txtLookupID.Text);
objEntity.ProcInitial = ddlProcedures.SelectedValue;
objEntity.VariableName = lblPrefix.Text + txtVariableName.Text.Replace("@XXX_", "");
objEntity.DisplayName = txtDiplayName.Text;
objEntity.ControlType = ddlControlType.SelectedItem.Text;
objEntity.LookupCatName = txtLookupCat.Text;
objEntity.CreatedBy = 1;
objEntity.IsRequried = chkMandatory.Checked;
objEntity.IsActive = chkActive.Checked;
if (cls_InputVariable_BAL.Save_InputVariable_BAL(objEntity) > 0)
{
lblerr.Text = "Record saved";
Get_InputVariableData();
}
ResetAllControls();
}
catch (Exception ex)
{
lblerr.Text = "Save Input variables - " + ex.Message;
}
}
public static string Save_InputVariable_BAL(InputVariable_Entity objEntity, ref string errmsg)
{
try
{
cls_InputVariable_DAL objdal = new cls_InputVariable_DAL();
return(objdal.Save_InputVariable_DAL(objEntity, ref errmsg));
}
catch (Exception ex)
{
return("Error in saving");
throw new Exception(ex.Message);
}
}
