public void LoadForm(int id)
{
ResetForm();
SStaff_SStaff provider = ServiceInterfaceManager.SStaff_SStaff_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id);
if (provider != null)
{
lblIen.Text = provider.StaffIEN;
lblLastName.Text = provider.LastName;
lblFirstName.Text = provider.FirstName;
if (provider.Sta3n != null)
{
lblStation.Text = provider.Sta3n.Value.ToString();
}
lblCity.Text = provider.City;
lblState.Text = provider.StateName;
}
else
{
linkViewDetails.Visible = false;
}
}
public static Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, SStaff_SStaff objSave)
{
Int32 objReturn = 0;
SStaff_SStaffDB objDB = new SStaff_SStaffDB();
objReturn = objDB.Save(CURRENT_USER, CURRENT_REGISTRY_ID, objSave);
return(objReturn);
}
public static SStaff_SStaff GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 Provider_ID)
{
SStaff_SStaff objReturn = null;
SStaff_SStaffDB objDB = new SStaff_SStaffDB();
objReturn = objDB.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, Provider_ID);
return(objReturn);
}
public SStaff_SStaff ParseReaderComplete(DataRow row)
{
SStaff_SStaff staff = ParseReaderCustom(row);
if (staff != null)
{
REFERRALDB rEFERRALDB = new REFERRALDB();
staff.REFERRAL = rEFERRALDB.ParseReaderCustom(row);
}
return(staff);
}
private void LoadProvider(int id)
{
SStaff_SStaff provider = ServiceInterfaceManager.SStaff_SStaff_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id);
if (provider != null)
{
hideResultId.Value = provider.Provider_ID.ToString();
txtLastName.Text = provider.LastName;
txtFirstName.Text = provider.FirstName;
txtGender.Text = provider.Gender;
txtCity.Text = provider.City;
txtState.Text = provider.StateName;
txtPostalCode.Text = provider.ZipCode;
}
}
private void LoadProvider(int id)
{
SStaff_SStaff provider = ServiceInterfaceManager.SStaff_SStaff_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id);
if (provider != null)
{
hideProviderId.Value = provider.Provider_ID.ToString();
if (!string.IsNullOrEmpty(provider.LastName) && !string.IsNullOrEmpty(provider.FirstName))
{
txtProvider.Text = provider.LastName + ", " + provider.FirstName;
}
else if (!string.IsNullOrEmpty(provider.LastName))
{
txtProvider.Text = provider.LastName;
}
else if (!string.IsNullOrEmpty(provider.FirstName))
{
txtProvider.Text = provider.FirstName;
}
}
}
public static Boolean Delete(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, SStaff_SStaff objDelete)
{
return(Delete(CURRENT_USER, CURRENT_REGISTRY_ID, objDelete.Provider_ID));
}
public SStaff_SStaff ParseReaderCustom(DataRow row)
{
SStaff_SStaff objReturn = new SStaff_SStaff
{
City = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_City")),
CommercialPhone = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_CommercialPhone")),
CreatedByStaffSID = (Int32?)GetNullableObject(row.Field <object>("SStaff_SStaff_CreatedByStaffSID")),
DEA = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_DEA")),
Degree = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_Degree")),
DelegateOfStaffIEN = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_DelegateOfStaffIEN")),
DelegateOfStaffSID = (Int32?)GetNullableObject(row.Field <object>("SStaff_SStaff_DelegateOfStaffSID")),
DelegationDate = (DateTime?)GetNullableObject(row.Field <object>("SStaff_SStaff_DelegationDate")),
DelegationLevel = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_DelegationLevel")),
DigitalPager = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_DigitalPager")),
ElectronicSignatureCodeFlag = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_ElectronicSignatureCodeFlag")),
EmailAddress = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_EmailAddress")),
EnteredDate = (DateTime?)GetNullableObject(row.Field <object>("SStaff_SStaff_EnteredDate")),
ETLBatchID = (Int32?)GetNullableObject(row.Field <object>("SStaff_SStaff_ETLBatchID")),
FaxNumber = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_FaxNumber")),
FirstName = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_FirstName")),
Gender = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_Gender")),
HINQEmployeeNumberFlag = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_HINQEmployeeNumberFlag")),
HomePhone = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_HomePhone")),
InactivationDate = (DateTime?)GetNullableObject(row.Field <object>("SStaff_SStaff_InactivationDate")),
LastEditedDateTime = (DateTime?)GetNullableObject(row.Field <object>("SStaff_SStaff_LastEditedDateTime")),
LastName = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_LastName")),
LastSignonDateTime = (DateTime?)GetNullableObject(row.Field <object>("SStaff_SStaff_LastSignonDateTime")),
LastUsedTerminalType = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_LastUsedTerminalType")),
MailCode = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_MailCode")),
MiddleName = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_MiddleName")),
NetworkUsername = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_NetworkUsername")),
NPI = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_NPI")),
NPIAuthorizedReleaseFlag = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_NPIAuthorizedReleaseFlag")),
OfficePhone = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_OfficePhone")),
OpCode = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_OpCode")),
PACFlag = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_PACFlag")),
Phone3 = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_Phone3")),
Phone4 = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_Phone4")),
PositionTitle = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_PositionTitle")),
Provider_ID = (Int32)GetNullableObject(row.Field <object>("SStaff_SStaff_Provider_ID")),
ProviderClass = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_ProviderClass")),
ProviderClassSID = (Int32?)GetNullableObject(row.Field <object>("SStaff_SStaff_ProviderClassSID")),
ProviderScheduleType = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_ProviderScheduleType")),
Room = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_Room")),
ServiceComputationDate = (DateTime?)GetNullableObject(row.Field <object>("SStaff_SStaff_ServiceComputationDate")),
ServiceSection = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_ServiceSection")),
ServiceSectionSID = (Int32?)GetNullableObject(row.Field <object>("SStaff_SStaff_ServiceSectionSID")),
ServiceType = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_ServiceType")),
SignatureBlockName = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_SignatureBlockName")),
SignatureBlockTitle = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_SignatureBlockTitle")),
SocialWorkerImmediateSupervisorStaffSID = (Int32?)GetNullableObject(row.Field <object>("SStaff_SStaff_SocialWorkerImmediateSupervisorStaffSID")),
SocialWorkerPositionTitle = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_SocialWorkerPositionTitle")),
Sta3n = (Int16?)GetNullableObject(row.Field <object>("SStaff_SStaff_Sta3n")),
StaffIEN = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_StaffIEN")),
StaffName = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_StaffName")),
StaffNamePrefix = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_StaffNamePrefix")),
StaffNameSuffix = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_StaffNameSuffix")),
StaffSID = (Int32?)GetNullableObject(row.Field <object>("SStaff_SStaff_StaffSID")),
StateName = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_StateName")),
StreetAddress1 = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_StreetAddress1")),
StreetAddress2 = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_StreetAddress2")),
StreetAddress3 = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_StreetAddress3")),
SupplyEmployee = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_SupplyEmployee")),
TemporaryAddress1 = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_TemporaryAddress1")),
TemporaryAddress2 = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_TemporaryAddress2")),
TemporaryAddress3 = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_TemporaryAddress3")),
TemporaryAddressEndDate = (DateTime?)GetNullableObject(row.Field <object>("SStaff_SStaff_TemporaryAddressEndDate")),
TemporaryAddressStartDate = (DateTime?)GetNullableObject(row.Field <object>("SStaff_SStaff_TemporaryAddressStartDate")),
TemporaryCity = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_TemporaryCity")),
TemporaryStateName = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_TemporaryStateName")),
TemporaryZipCode = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_TemporaryZipCode")),
TerminationDate = (DateTime?)GetNullableObject(row.Field <object>("SStaff_SStaff_TerminationDate")),
TerminationReason = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_TerminationReason")),
VANumber = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_VANumber")),
VerifyCodeLastChangedDate = (DateTime?)GetNullableObject(row.Field <object>("SStaff_SStaff_VerifyCodeLastChangedDate")),
VistaCreateDate = (DateTime?)GetNullableObject(row.Field <object>("SStaff_SStaff_VistaCreateDate")),
VistaEditDate = (DateTime?)GetNullableObject(row.Field <object>("SStaff_SStaff_VistaEditDate")),
VoicePager = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_VoicePager")),
ZipCode = (string)GetNullableObject(row.Field <object>("SStaff_SStaff_ZipCode"))
};
return(objReturn);
}
public SStaff_SStaff GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 Provider_ID)
{
SStaff_SStaff 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_SStaff_SStaff_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("@Provider_ID", Provider_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, SStaff_SStaff objSave)
{
Int32 objReturn = 0;
SqlConnection sConn = null;
SqlCommand sCmd = null;
SqlParameter p = null;
try
{
sConn = new SqlConnection(SqlConnectionString);
sConn.Open();
sCmd = new SqlCommand("CRS.usp_SStaff_SStaff_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("@City", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.City);
p = new SqlParameter("@CommercialPhone", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.CommercialPhone);
p = new SqlParameter("@CreatedByStaffSID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.CreatedByStaffSID);
p = new SqlParameter("@DEA", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.DEA);
p = new SqlParameter("@Degree", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.Degree);
p = new SqlParameter("@DelegateOfStaffIEN", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.DelegateOfStaffIEN);
p = new SqlParameter("@DelegateOfStaffSID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.DelegateOfStaffSID);
p = new SqlParameter("@DelegationDate", SqlDbType.Date, 3);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.DelegationDate);
p = new SqlParameter("@DelegationLevel", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.DelegationLevel);
p = new SqlParameter("@DigitalPager", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.DigitalPager);
p = new SqlParameter("@ElectronicSignatureCodeFlag", SqlDbType.Char, 1);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.ElectronicSignatureCodeFlag);
p = new SqlParameter("@EmailAddress", SqlDbType.VarChar, 100);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.EmailAddress);
p = new SqlParameter("@EnteredDate", SqlDbType.Date, 3);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.EnteredDate);
p = new SqlParameter("@ETLBatchID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.ETLBatchID);
p = new SqlParameter("@FaxNumber", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.FaxNumber);
p = new SqlParameter("@FirstName", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.FirstName);
p = new SqlParameter("@Gender", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.Gender);
p = new SqlParameter("@HINQEmployeeNumberFlag", SqlDbType.Char, 1);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.HINQEmployeeNumberFlag);
p = new SqlParameter("@HomePhone", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.HomePhone);
p = new SqlParameter("@InactivationDate", SqlDbType.Date, 3);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.InactivationDate);
p = new SqlParameter("@LastEditedDateTime", SqlDbType.SmallDateTime, 4);
p.Precision = 16;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.LastEditedDateTime);
p = new SqlParameter("@LastName", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.LastName);
p = new SqlParameter("@LastSignonDateTime", SqlDbType.SmallDateTime, 4);
p.Precision = 16;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.LastSignonDateTime);
p = new SqlParameter("@LastUsedTerminalType", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.LastUsedTerminalType);
p = new SqlParameter("@MailCode", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.MailCode);
p = new SqlParameter("@MiddleName", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.MiddleName);
p = new SqlParameter("@NetworkUsername", SqlDbType.VarChar, 100);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.NetworkUsername);
p = new SqlParameter("@NPI", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.NPI);
p = new SqlParameter("@NPIAuthorizedReleaseFlag", SqlDbType.Char, 1);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.NPIAuthorizedReleaseFlag);
p = new SqlParameter("@OfficePhone", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.OfficePhone);
p = new SqlParameter("@OpCode", SqlDbType.Char, 1);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.OpCode);
p = new SqlParameter("@PACFlag", SqlDbType.Char, 1);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.PACFlag);
p = new SqlParameter("@Phone3", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.Phone3);
p = new SqlParameter("@Phone4", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.Phone4);
p = new SqlParameter("@PositionTitle", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.PositionTitle);
p = new SqlParameter("@Provider_ID", SqlDbType.Int, 4);
p.Direction = ParameterDirection.InputOutput;
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.Provider_ID);
p = new SqlParameter("@ProviderClass", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.ProviderClass);
p = new SqlParameter("@ProviderClassSID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.ProviderClassSID);
p = new SqlParameter("@ProviderScheduleType", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.ProviderScheduleType);
p = new SqlParameter("@Room", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.Room);
p = new SqlParameter("@ServiceComputationDate", SqlDbType.Date, 3);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.ServiceComputationDate);
p = new SqlParameter("@ServiceSection", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.ServiceSection);
p = new SqlParameter("@ServiceSectionSID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.ServiceSectionSID);
p = new SqlParameter("@ServiceType", SqlDbType.Char, 1);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.ServiceType);
p = new SqlParameter("@SignatureBlockName", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.SignatureBlockName);
p = new SqlParameter("@SignatureBlockTitle", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.SignatureBlockTitle);
p = new SqlParameter("@SocialWorkerImmediateSupervisorStaffSID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.SocialWorkerImmediateSupervisorStaffSID);
p = new SqlParameter("@SocialWorkerPositionTitle", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.SocialWorkerPositionTitle);
p = new SqlParameter("@Sta3n", SqlDbType.SmallInt, 2);
p.Precision = 5;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.Sta3n);
p = new SqlParameter("@StaffIEN", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.StaffIEN);
p = new SqlParameter("@StaffName", SqlDbType.VarChar, 100);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.StaffName);
p = new SqlParameter("@StaffNamePrefix", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.StaffNamePrefix);
p = new SqlParameter("@StaffNameSuffix", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.StaffNameSuffix);
p = new SqlParameter("@StaffSID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.StaffSID);
p = new SqlParameter("@StateName", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.StateName);
p = new SqlParameter("@StreetAddress1", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.StreetAddress1);
p = new SqlParameter("@StreetAddress2", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.StreetAddress2);
p = new SqlParameter("@StreetAddress3", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.StreetAddress3);
p = new SqlParameter("@SupplyEmployee", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.SupplyEmployee);
p = new SqlParameter("@TemporaryAddress1", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.TemporaryAddress1);
p = new SqlParameter("@TemporaryAddress2", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.TemporaryAddress2);
p = new SqlParameter("@TemporaryAddress3", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.TemporaryAddress3);
p = new SqlParameter("@TemporaryAddressEndDate", SqlDbType.Date, 3);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.TemporaryAddressEndDate);
p = new SqlParameter("@TemporaryAddressStartDate", SqlDbType.Date, 3);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.TemporaryAddressStartDate);
p = new SqlParameter("@TemporaryCity", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.TemporaryCity);
p = new SqlParameter("@TemporaryStateName", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.TemporaryStateName);
p = new SqlParameter("@TemporaryZipCode", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.TemporaryZipCode);
p = new SqlParameter("@TerminationDate", SqlDbType.Date, 3);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.TerminationDate);
p = new SqlParameter("@TerminationReason", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.TerminationReason);
p = new SqlParameter("@VANumber", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.VANumber);
p = new SqlParameter("@VerifyCodeLastChangedDate", SqlDbType.Date, 3);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.VerifyCodeLastChangedDate);
p = new SqlParameter("@VistaCreateDate", SqlDbType.DateTime, 8);
p.Precision = 23;
p.Scale = 3;
AddParameter(ref sCmd, ref p, objSave.VistaCreateDate);
p = new SqlParameter("@VistaEditDate", SqlDbType.DateTime, 8);
p.Precision = 23;
p.Scale = 3;
AddParameter(ref sCmd, ref p, objSave.VistaEditDate);
p = new SqlParameter("@VoicePager", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.VoicePager);
p = new SqlParameter("@ZipCode", SqlDbType.VarChar, 50);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.ZipCode);
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();
LogManager.LogTiming(logDetails);
objReturn = (Int32)sCmd.Parameters["@Provider_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 (sCmd != null)
{
sCmd.Dispose();
sCmd = null;
}
if (sConn != null)
{
if (sConn.State != ConnectionState.Closed)
{
sConn.Close();
}
sConn.Dispose();
sConn = null;
}
}
return(objReturn);
}