public static Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_WKFCASETYPE objSave)
{
Int32 objReturn = 0;
STD_WKFCASETYPEDB objDB = new STD_WKFCASETYPEDB();
objReturn = objDB.Save(CURRENT_USER, CURRENT_REGISTRY_ID, objSave);
return(objReturn);
}
public static STD_WKFCASETYPE GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 ID)
{
STD_WKFCASETYPE objReturn = null;
STD_WKFCASETYPEDB objDB = new STD_WKFCASETYPEDB();
objReturn = objDB.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, ID);
return(objReturn);
}
private void LoadForm(int id)
{
ResetForm();
STD_WKFCASETYPE workstream = ServiceInterfaceManager.STD_WKFCASETYPE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id);
if (workstream != null)
{
hideWorkstreamId.Value = workstream.ID.ToString();
txtWorkstreamName.Text = workstream.Name;
txtWorkstreamCode.Text = workstream.CODE;
txtWorkstreamSortOrder.Text = workstream.SORT_ORDER.ToString();
txtWorkstreamDescription.Text = workstream.DESCRIPTION_TEXT;
chkAutoCreated.Checked = workstream.AUTO_CREATE.GetValueOrDefault();
}
}
private void ResetForm()
{
hideActivityId.Value = string.Empty;
listActivityName.ClearSelection();
listActivityName.Items.Clear();
listActivityName.Enabled = true;
WKF_CASE workstream = ServiceInterfaceManager.WKF_CASE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, UserSession.CurrentWorkstreamId);
if (workstream != null)
{
hideWorkstreamId.Value = workstream.WKF_CASE_ID.ToString();
STD_WKFCASETYPE type = ServiceInterfaceManager.STD_WKFCASETYPE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, workstream.STD_WKFCASETYPE_ID);
if (type != null)
{
txtWorkstreamName.Text = type.Name;
List <STD_WKFACTIVITYTYPE> cases = ServiceInterfaceManager.STD_WKFACTIVITYTYPE_GET_ALL_BY_WORKSTREAM(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, type.ID);
listActivityName.Items.Add(new ListItem("", "0"));
listActivityName.AppendDataBoundItems = true;
if (cases != null)
{
listActivityName.DataSource = cases;
listActivityName.DataBind();
}
}
}
txtContactName.Text = string.Empty;
txtContactEmail.Text = string.Empty;
txtContactPhone.Text = string.Empty;
txtBestCallBackTime.Text = string.Empty;
txtAddressLine1.Text = string.Empty;
txtAddressLine2.Text = string.Empty;
txtAddressLine3.Text = string.Empty;
txtCity.Text = string.Empty;
txtState.Text = string.Empty;
txtPostalCode.Text = string.Empty;
txtCountry.Text = string.Empty;
txtInfoConveyed.Text = string.Empty;
txtInfoReceived.Text = string.Empty;
}
public STD_WKFCASETYPE ParseReaderCustom(DataRow row)
{
STD_WKFCASETYPE objReturn = new STD_WKFCASETYPE
{
AUTO_CREATE = (bool?)GetNullableObject(row.Field <object>("STD_WKFCASETYPE_AUTO_CREATE")),
CODE = (string)GetNullableObject(row.Field <object>("STD_WKFCASETYPE_CODE")),
CREATED = (DateTime)GetNullableObject(row.Field <object>("STD_WKFCASETYPE_CREATED")),
CREATEDBY = (string)GetNullableObject(row.Field <object>("STD_WKFCASETYPE_CREATEDBY")),
DESCRIPTION_TEXT = (string)GetNullableObject(row.Field <object>("STD_WKFCASETYPE_DESCRIPTION_TEXT")),
ID = (Int32)GetNullableObject(row.Field <object>("STD_WKFCASETYPE_ID")),
INACTIVE_DATE = (DateTime?)GetNullableObject(row.Field <object>("STD_WKFCASETYPE_INACTIVE_DATE")),
INACTIVE_FLAG = (bool)GetNullableObject(row.Field <object>("STD_WKFCASETYPE_INACTIVE_FLAG")),
Name = (string)GetNullableObject(row.Field <object>("STD_WKFCASETYPE_Name")),
SORT_ORDER = (Int32)GetNullableObject(row.Field <object>("STD_WKFCASETYPE_SORT_ORDER")),
STD_REGISTRY_ID = (Int32?)GetNullableObject(row.Field <object>("STD_WKFCASETYPE_STD_REGISTRY_ID")),
UPDATED = (DateTime)GetNullableObject(row.Field <object>("STD_WKFCASETYPE_UPDATED")),
UPDATEDBY = (string)GetNullableObject(row.Field <object>("STD_WKFCASETYPE_UPDATEDBY"))
};
return(objReturn);
}
private bool SaveForm(ref string strResult)
{
STD_WKFCASETYPE workstream = null;
if (string.IsNullOrEmpty(txtWorkstreamName.Text))
{
strResult = "Workstream Name is Required<br /><br />";
}
else if (string.IsNullOrEmpty(txtWorkstreamCode.Text))
{
strResult = "Workstream Code is Required<br /><br />";
}
else if (string.IsNullOrEmpty(txtWorkstreamSortOrder.Text))
{
strResult = "Sort Order is Required<br /><br />";
}
else if (string.IsNullOrEmpty(txtWorkstreamDescription.Text))
{
strResult = "Description is Required<br /><br />";
}
else
{
int id = 0;
if (!string.IsNullOrEmpty(hideWorkstreamId.Value))
{
int.TryParse(hideWorkstreamId.Value, out id);
}
if (id > 0)
{
workstream = ServiceInterfaceManager.STD_WKFCASETYPE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id);
}
if (workstream == null)
{
workstream = new STD_WKFCASETYPE();
}
workstream.STD_REGISTRY_ID = UserSession.CurrentRegistryId;
workstream.CREATEDBY = workstream.UPDATEDBY = HttpContext.Current.User.Identity.Name;
workstream.Name = txtWorkstreamName.Text;
workstream.CODE = txtWorkstreamCode.Text;
int order = 0;
int.TryParse(txtWorkstreamSortOrder.Text, out order);
workstream.SORT_ORDER = order;
workstream.DESCRIPTION_TEXT = txtWorkstreamDescription.Text;
workstream.AUTO_CREATE = chkAutoCreated.Checked;
workstream.ID = ServiceInterfaceManager.STD_WKFCASETYPE_SAVE(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, workstream);
if (workstream.ID > 0)
{
hideWorkstreamId.Value = workstream.ID.ToString();
strResult = "Save successful<br /><br />";
return(true);
}
else
{
strResult = "Error saving Workstream, please try again<br /><br />";
}
}
// }
//else
// {
// strResult = "<ul><li>Workstream Name is Required</li></ul>";
return(false);
}
public STD_WKFCASETYPE GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 ID)
{
STD_WKFCASETYPE objReturn = null;
SqlConnection sConn = null;
SqlCommand sCmd = null;
SqlDataAdapter sAdapter = null;
DataSet objTemp = null;
try
{
sConn = new SqlConnection(SqlConnectionString);
sConn.Open();
sCmd = new SqlCommand("CRS.usp_STD_WKFCASETYPE_getitem", sConn);
sCmd.CommandTimeout = SqlCommandTimeout;
sCmd.CommandType = CommandType.StoredProcedure;
sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER);
sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID);
sCmd.Parameters.AddWithValue("@ID", ID);
objTemp = new DataSet();
sAdapter = new SqlDataAdapter(sCmd);
LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
sAdapter.Fill(objTemp);
LogManager.LogTiming(logDetails);
CheckDataSet(objTemp);
if (objTemp != null && objTemp.Tables.Count > 0 && objTemp.Tables[0].Rows.Count > 0)
{
objReturn = ParseReader(objTemp.Tables[0].Rows[0]);
}
sConn.Close();
}
catch (Exception ex)
{
LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
throw ex;
}
finally
{
if (sAdapter != null)
{
sAdapter.Dispose();
sAdapter = null;
}
if (sCmd != null)
{
sCmd.Dispose();
sCmd = null;
}
if (sConn != null)
{
if (sConn.State != ConnectionState.Closed)
{
sConn.Close();
}
sConn.Dispose();
sConn = null;
}
}
return(objReturn);
}
public Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_WKFCASETYPE objSave)
{
Int32 objReturn = 0;
SqlConnection sConn = null;
SqlCommand sCmd = null;
SqlParameter p = null;
SqlDataAdapter sAdapter = null;
DataSet objTemp = null;
try
{
sConn = new SqlConnection(SqlConnectionString);
sConn.Open();
sCmd = new SqlCommand("CRS.usp_STD_WKFCASETYPE_save", sConn);
sCmd.CommandTimeout = SqlCommandTimeout;
sCmd.CommandType = CommandType.StoredProcedure;
sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER);
sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID);
p = new SqlParameter("@AUTO_CREATE", SqlDbType.Bit, 1);
p.Precision = 1;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.AUTO_CREATE);
p = new SqlParameter("@CODE", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.CODE);
p = new SqlParameter("@CREATED", SqlDbType.DateTime, 8);
p.Precision = 23;
p.Scale = 3;
AddParameter(ref sCmd, ref p, objSave.CREATED);
p = new SqlParameter("@CREATEDBY", SqlDbType.VarChar, 30);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.CREATEDBY);
p = new SqlParameter("@DESCRIPTION_TEXT", SqlDbType.VarChar, 500);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.DESCRIPTION_TEXT);
p = new SqlParameter("@ID", SqlDbType.Int, 4);
p.Direction = ParameterDirection.InputOutput;
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.ID);
p = new SqlParameter("@INACTIVE_DATE", SqlDbType.DateTime, 8);
p.Precision = 23;
p.Scale = 3;
AddParameter(ref sCmd, ref p, objSave.INACTIVE_DATE);
p = new SqlParameter("@INACTIVE_FLAG", SqlDbType.Bit, 1);
p.Precision = 1;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.INACTIVE_FLAG);
p = new SqlParameter("@Name", SqlDbType.VarChar, 100);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.Name);
p = new SqlParameter("@SORT_ORDER", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.SORT_ORDER);
p = new SqlParameter("@STD_REGISTRY_ID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.STD_REGISTRY_ID);
p = new SqlParameter("@UPDATED", SqlDbType.DateTime, 8);
p.Precision = 23;
p.Scale = 3;
AddParameter(ref sCmd, ref p, objSave.UPDATED);
p = new SqlParameter("@UPDATEDBY", SqlDbType.VarChar, 30);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.UPDATEDBY);
objTemp = new DataSet();
sAdapter = new SqlDataAdapter(sCmd);
LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
//int cnt = sCmd.ExecuteNonQuery();
sAdapter.Fill(objTemp);
LogManager.LogTiming(logDetails);
CheckDataSet(objTemp);
objReturn = (Int32)sCmd.Parameters["@ID"].Value;
sConn.Close();
}
catch (Exception ex)
{
LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
throw ex;
}
finally
{
if (sAdapter != null)
{
sAdapter.Dispose();
sAdapter = null;
}
if (sCmd != null)
{
sCmd.Dispose();
sCmd = null;
}
if (sConn != null)
{
if (sConn.State != ConnectionState.Closed)
{
sConn.Close();
}
sConn.Dispose();
sConn = null;
}
}
return(objReturn);
}
public static Boolean Delete(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, STD_WKFCASETYPE objDelete)
{
return(Delete(CURRENT_USER, CURRENT_REGISTRY_ID, objDelete.ID));
}
