public static RemoteAuthentication ToWWCP(this User_Id UserId)
{
if (UserId.Format == UserIdFormats.eMA ||
UserId.Format == UserIdFormats.eMI3 ||
UserId.Format == UserIdFormats.EVCO ||
UserId.Format == UserIdFormats.EMP_SPEC)
{
return(RemoteAuthentication.FromRemoteIdentification(eMobilityAccount_Id.Parse(UserId.ToString())));
}
if (UserId.Format == UserIdFormats.RFID_UID)
{
return(RemoteAuthentication.FromAuthToken(Auth_Token.Parse(UserId.ToString())));
}
return(null);
}
private void btn_Inhouse_Documents_Click(object sender, EventArgs e)
{
Order_Uploads Orderuploads = new Order_Uploads("Update", int.Parse(Order_Id.ToString()), int.Parse(User_Id.ToString()), txt_Order_Number.Text.ToString(), Client_Id.ToString(), Sub_Client_Id.ToString());
Orderuploads.Show();
}
private void btn_Save_Click(object sender, EventArgs e)
{
Hashtable ht = new Hashtable();
DataTable dt = new System.Data.DataTable();
if (btn_Save.Text == "Submit")
{
StringBuilder bs = new StringBuilder();
bs.AppendLine("CASENUM=" + " " + txt_Oredr_No_CASENUM.Text.ToString());
bs.AppendLine("CTEFFDAT=" + " " + txt_Effective_date_CTEFDAT.Text.ToString());
bs.AppendLine("CTEFFTIM=" + " " + txt_Time_CTEFTIM.Text.ToString());
bs.AppendLine("AMHOUSHOLD=" + " " + txt_recording_information_AMHOUSHOLD.Text.ToString());
bs.AppendLine("CTOWNER=" + " " + txt_vesting_CTWNER.Text.ToString());
bs.AppendLine("POSSION=" + " " + txt_ownershiptyp_POSSION.Text.ToString());
bs.AppendLine("PROPTYPE=" + " " + txt_propertytype_PROPTYPE.Text.ToString());
bs.AppendLine("PROPSTRE=" + " " + txt_streetName_PROPSTRE.Text.ToString());
bs.AppendLine("PROPCITY=" + " " + txt_city_name_PROPCITY.Text.ToString());
bs.AppendLine("STATELET=" + " " + txt_State_Abb_STATELET.Text.ToString());
bs.AppendLine("PROPZIP=" + " " + txt_Zip_Code_PROPZIP.Text.ToString());
bs.AppendLine("COUNTY=" + " " + txt_County_Name_COUNTY.Text.ToString());
bs.AppendLine("TPROPOTH=" + " " + txt_ownershiptype_TPROPOTH.Text.ToString());
bs.AppendLine("PARCELID=" + " " + txt_legaltype_SUBDIVN.Text.ToString());
bs.AppendLine("MAPREF=" + " " + txt_Map_Refrence_no_MAPEREF.Text.ToString());
bs.AppendLine("LOTUNIT=" + " " + txt_lot_or_unit_LOTUNIT.Text.ToString());
bs.AppendLine("BLKBLDG=" + " " + txt_Block_or_Building_Number_BLKBLDG.Text.ToString());
bs.AppendLine("SECTION=" + " " + txt_Section_Number_SECTION.Text.ToString());
bs.AppendLine("PHASE=" + " " + txt_Phase_Number_PHASE.Text.ToString());
bs.AppendLine("ACREAGE=" + " " + txt_Acreage_ACREAGE.Text.ToString());
bs.AppendLine("BYR1NAM1=" + " " + txt_Borrower_BYRNAM1.Text.ToString());
bs.AppendLine("BYR2NAM1=" + " " + txt_Co_Borrower_BYR2NAM1.Text.ToString());
bs.AppendLine("PROPDES=" + " " + txt_Legal_Description_PROPDES.Text.ToString());
bs.AppendLine("EX40TEXT=" + " " + txt_Texes_Assesment_EX40TEXT.Text.ToString());
bs.AppendLine("RE18TEXT=" + " " + txt_Mortgage_Information_RE18TEXT.Text.ToString());
bs.AppendLine("RE19TEXT=" + " " + txt_Assignment_Information_RE19TEXT.Text.ToString());
bs.AppendLine("RE20TEXT=" + " " + txt_Common_verbiage_RE20TEXT.Text.ToString());
bs.AppendLine("RE21TEXT=" + " " + txt_Judgment_verbiage_RE21TEXT.Text.ToString());
bs.AppendLine("RE22TEXT=" + " " + txt_Names_Run_verbiage_RE22TEXT.Text.ToString());
bs.AppendLine("EX12TEXT=" + " " + txt_Common_verbiage_EX12TEXT.Text.ToString());
bs.AppendLine("OPINSD=" + " " + txt_OPINSD.Text.ToString());
bs.AppendLine("CTOWNER=" + " " + txt_Current_owner_name_CTOWNER.Text.ToString());
bs.AppendLine("OTINSD=" + " " + txt_OTINSD.Text.ToString());
bs.AppendLine("OTCOVR=" + " " + txt_OTCOVR.Text.ToString());
bs.AppendLine("DERVBY=" + " " + txt_Deed_type.Text.ToString());
bs.AppendLine("DERVDATE=" + " " + txt_Dated_Date.Text.ToString());
bs.AppendLine("DERVRECO=" + " " + txt_Recorded_Date.Text.ToString());
bs.AppendLine("DERVRWBK=" + " " + txt_Book_DERVRWBK.Text.ToString());
bs.AppendLine("DERVRWPG=" + " " + txt_page_DERVRWPG.Text.ToString());
bs.AppendLine("RE01TEXT=" + " " + txt_mortgage_information_RE01TEXT.Text.ToString());
bs.AppendLine("RE02TEXT=" + " " + txt_mortgage_information_RE02TEXT.Text.ToString());
bs.AppendLine("RE03TEXT=" + " " + txt_24month_chain_RE03TEXT.Text.ToString());
bs.AppendLine("EX01TEXT=" + " " + txt_Tax_verbiage_EX01TEXT.Text.ToString());
if (Directory.Exists(@"C:\PxtNotes"))
{
src = @"C:\OMS_Notes\PxtNotes-" + User_Id + ".pxt";
des = @"\\192.168.12.33\oms\" + Client + @"\" + Subclient + @"\" + Orderno + @"\PxtNotes-" + User_Id.ToString() + ".pxt";
}
else
{
Directory.CreateDirectory(@"C:\PxtNotes");
src = @"C:\PxtNotes\PxtNotes-" + User_Id + ".pxt";
des = @"\\192.168.12.33\oms\" + Client + @"\" + Subclient + @"\" + Orderno + @"\PxtNotes-" + User_Id.ToString() + ".pxt";
}
Directory.CreateDirectory(@"\\192.168.12.33\oms\" + Client + @"\" + Subclient + @"\" + Orderno);
DirectoryEntry de = new DirectoryEntry(@"\\192.168.12.33\oms\" + Client + @"\" + Subclient + @"\" + Orderno, "administrator", "password1$");
de.Username = "******";
de.Password = "******";
FileStream fs = new FileStream(src, FileMode.Append, FileAccess.Write, FileShare.Write);
fs.Flush();
fs.Close();
File.WriteAllText(src, bs.ToString());
File.Copy(src, des, true);
System.IO.FileInfo f = new System.IO.FileInfo(src);
System.IO.FileInfo f1 = new System.IO.FileInfo(des);
filesize = f.Length;
file_extension = f.Extension;
GetFileSize(filesize);
Hashtable htup = new Hashtable();
DataTable dtup = new DataTable();
htup.Add("@Trans", "CHECK_EXIST_DOCUMENT");
htup.Add("@Order_Id", Order_Id);
htup.Add("@Document_Name", "PxtFile");
dtup = dataaccess.ExecuteSP("Sp_Order_Pxt_Format", htup);
if (dtup.Rows.Count > 0)
{
//UPDATE_DOCUMENT_PATH
htup.Clear(); dtup.Clear();
htup.Add("@Trans", "UPDATE_DOCUMENT_PATH");
htup.Add("@Document_Path", des);
htup.Add("@Order_Id", Order_Id);
dtup = dataaccess.ExecuteSP("Sp_Order_Pxt_Format", htup);
}
else
{
//INSERT
htup.Clear(); dtup.Clear();
htup.Add("@Trans", "INSERT");
htup.Add("@Order_ID", int.Parse(Order_Id.ToString()));
htup.Add("@File_Size", File_size);
htup.Add("@Instuction", "PxtFile");
htup.Add("@Document_Path", des);
htup.Add("@Document_Name", "PxtFile");
htup.Add("@Extension", file_extension);
htup.Add("@Inserted_By", User_Id);
htup.Add("@Inserted_date", DateTime.Now);
dtup = dataaccess.ExecuteSP("Sp_Document_Upload", htup);
}
Hashtable htcheck = new Hashtable();
DataTable dtcheck = new System.Data.DataTable();
htcheck.Add("@Trans", "SELECT");
htcheck.Add("@Order_Id", Order_Id);
dtcheck = dataaccess.ExecuteSP("Sp_Order_Pxt_Format", htcheck);
if (dtcheck.Rows.Count <= 0)
{
ht.Add("@Trans", "INSERT");
ht.Add("@Order_Id", Order_Id);
ht.Add("@Order_Num_CASENUM", txt_Oredr_No_CASENUM.Text);
ht.Add("@Effectiv_Date_CTEFFDAT", txt_Effective_date_CTEFDAT.Text);
ht.Add("@Time_CTEFFTIM", txt_Time_CTEFTIM.Text);
ht.Add("@Recod_Info_AMHOUSHOLD", txt_recording_information_AMHOUSHOLD.Text);
ht.Add("@Vesting_CTOWNER", txt_vesting_CTWNER.Text);
ht.Add("@Owenership_POSSION", txt_ownershiptyp_POSSION.Text);
ht.Add("@Property_Type_PROPTYPE", txt_propertytype_PROPTYPE.Text);
ht.Add("@Street_Name_PROPSTRE", txt_streetName_PROPSTRE.Text);
ht.Add("@City_Name_PROPCITY", txt_city_name_PROPCITY.Text);
ht.Add("@State_Abb_STATELET", txt_State_Abb_STATELET.Text);
ht.Add("@Zip_Code_PROPZIP", txt_Zip_Code_PROPZIP.Text);
ht.Add("@County_Name_COUNTY", txt_County_Name_COUNTY.Text);
ht.Add("@Ownership_type_TPROPOTH", txt_ownershiptype_TPROPOTH.Text);
ht.Add("@Legal_Type_SUBDIVN", txt_legaltype_SUBDIVN.Text);
ht.Add("@APN_PARCELID", txt_APN_PARCELID.Text);
ht.Add("@Map_Reference_MAPREF", txt_Map_Refrence_no_MAPEREF.Text);
ht.Add("@Lot_Unit_No_LOTUNIT", txt_lot_or_unit_LOTUNIT.Text);
ht.Add("@Block_Building_Number_BLKBLDG", txt_Block_or_Building_Number_BLKBLDG.Text);
ht.Add("@Section_Number_SECTION", txt_Section_Number_SECTION.Text);
ht.Add("@Phasse_Number_PHASE", txt_Phase_Number_PHASE.Text);
ht.Add("@Acreage_ACREAGE", txt_Acreage_ACREAGE.Text);
ht.Add("@Borrower_BYR1NAM1", txt_Borrower_BYRNAM1.Text);
ht.Add("@Co_Borrower_BYR2NAM1", txt_Co_Borrower_BYR2NAM1.Text);
ht.Add("@Legal_Description_PROPDES", txt_Legal_Description_PROPDES.Text);
ht.Add("@Tax_Assesment_EX40TEXT", txt_Texes_Assesment_EX40TEXT.Text);
ht.Add("@Mortgage_Information_RE18TEXT", txt_Mortgage_Information_RE18TEXT.Text);
ht.Add("@Assignment_Information_RE19TEXT", txt_Assignment_Information_RE19TEXT.Text);
ht.Add("@Common_verbiage_RE20TEXT", txt_Common_verbiage_RE20TEXT.Text);
ht.Add("@Judgment_verbiage_RE21TEXT", txt_Judgment_verbiage_RE21TEXT.Text);
ht.Add("@Names_Run_verbiage_RE22TEXT", txt_Names_Run_verbiage_RE22TEXT.Text);
ht.Add("@Common_verbiage_EX12TEXT", txt_Common_verbiage_EX12TEXT.Text);
ht.Add("@Current_owner_name_CTOWNER", txt_Current_owner_name_CTOWNER.Text);
ht.Add("@OTINSD", txt_OTINSD.Text);
ht.Add("@LPINSD", txt_LPINSD.Text);
ht.Add("@Cover_Date_OTCOVR", txt_OTCOVR.Text);
ht.Add("@Deed_Type_DERVBY", txt_Deed_type.Text);
ht.Add("@Dated_Date_DERVDATE", txt_Dated_Date.Text);
ht.Add("@Recorded_Date_DERVRECO", txt_Recorded_Date.Text);
ht.Add("@Book_DERVRWBK", txt_Book_DERVRWBK.Text);
ht.Add("@Page_DERVRWPG", txt_page_DERVRWPG.Text);
ht.Add("@Mortgage_Information_RE01TEXT", txt_mortgage_information_RE01TEXT.Text);
ht.Add("@Mortgage_Information_RE02TEXT", txt_mortgage_information_RE02TEXT.Text);
ht.Add("@T24_Month_chain_verbiage_RE03TEXT", txt_24month_chain_RE03TEXT.Text);
ht.Add("@Tax_verbiage_EX01TEXT", txt_Tax_verbiage_EX01TEXT.Text);
//ht.Add("@Common_verbiage_EX02TEXT",txt_com);
//ht.Add("@Common_Legal_Verbiage_EX03TEXT","");
//ht.Add("@Easements_Verbiage_EX04TEXT","");
//ht.Add("@CCR_Verbiage_EX06TEXT","");
//ht.Add("@Taxes_verbiage_EX07TEXT","");
dt = dataaccess.ExecuteSP("Sp_Order_Pxt_Format", ht);
MessageBox.Show("Record Inserted Successfully");
CleanForm();
}
else
{
ht.Add("@Trans", "UPDATE");
ht.Add("@Order_Id", Order_Id);
ht.Add("@Order_Num_CASENUM", txt_Oredr_No_CASENUM.Text);
ht.Add("@Effectiv_Date_CTEFFDAT", txt_Effective_date_CTEFDAT.Text);
ht.Add("@Time_CTEFFTIM", txt_Time_CTEFTIM.Text);
ht.Add("@Recod_Info_AMHOUSHOLD", txt_recording_information_AMHOUSHOLD.Text);
ht.Add("@Vesting_CTOWNER", txt_vesting_CTWNER.Text);
ht.Add("@Owenership_POSSION", txt_ownershiptyp_POSSION.Text);
ht.Add("@Property_Type_PROPTYPE", txt_propertytype_PROPTYPE.Text);
ht.Add("@Street_Name_PROPSTRE", txt_streetName_PROPSTRE.Text);
ht.Add("@City_Name_PROPCITY", txt_city_name_PROPCITY.Text);
ht.Add("@State_Abb_STATELET", txt_State_Abb_STATELET.Text);
ht.Add("@Zip_Code_PROPZIP", txt_Zip_Code_PROPZIP.Text);
ht.Add("@County_Name_COUNTY", txt_County_Name_COUNTY.Text);
ht.Add("@Ownership_type_TPROPOTH", txt_ownershiptype_TPROPOTH.Text);
ht.Add("@Legal_Type_SUBDIVN", txt_legaltype_SUBDIVN.Text);
ht.Add("@APN_PARCELID", txt_APN_PARCELID.Text);
ht.Add("@Map_Reference_MAPREF", txt_Map_Refrence_no_MAPEREF.Text);
ht.Add("@Lot_Unit_No_LOTUNIT", txt_lot_or_unit_LOTUNIT.Text);
ht.Add("@Block_Building_Number_BLKBLDG", txt_Block_or_Building_Number_BLKBLDG.Text);
ht.Add("@Section_Number_SECTION", txt_Section_Number_SECTION.Text);
ht.Add("@Phasse_Number_PHASE", txt_Phase_Number_PHASE.Text);
ht.Add("@Acreage_ACREAGE", txt_Acreage_ACREAGE.Text);
ht.Add("@Borrower_BYR1NAM1", txt_Borrower_BYRNAM1.Text);
ht.Add("@Co_Borrower_BYR2NAM1", txt_Co_Borrower_BYR2NAM1.Text);
ht.Add("@Legal_Description_PROPDES", txt_Legal_Description_PROPDES.Text);
ht.Add("@Tax_Assesment_EX40TEXT", txt_Texes_Assesment_EX40TEXT.Text);
ht.Add("@Mortgage_Information_RE18TEXT", txt_Mortgage_Information_RE18TEXT.Text);
ht.Add("@Assignment_Information_RE19TEXT", txt_Assignment_Information_RE19TEXT.Text);
ht.Add("@Common_verbiage_RE20TEXT", txt_Common_verbiage_RE20TEXT.Text);
ht.Add("@Judgment_verbiage_RE21TEXT", txt_Judgment_verbiage_RE21TEXT.Text);
ht.Add("@Names_Run_verbiage_RE22TEXT", txt_Names_Run_verbiage_RE22TEXT.Text);
ht.Add("@Common_verbiage_EX12TEXT", txt_Common_verbiage_EX12TEXT.Text);
ht.Add("@Current_owner_name_CTOWNER", txt_Current_owner_name_CTOWNER.Text);
ht.Add("@OTINSD", txt_OTINSD.Text);
ht.Add("@LPINSD", txt_LPINSD.Text);
ht.Add("@Cover_Date_OTCOVR", txt_OTCOVR.Text);
ht.Add("@Deed_Type_DERVBY", txt_Deed_type.Text);
ht.Add("@Dated_Date_DERVDATE", txt_Dated_Date.Text);
ht.Add("@Recorded_Date_DERVRECO", txt_Recorded_Date.Text);
ht.Add("@Book_DERVRWBK", txt_Book_DERVRWBK.Text);
ht.Add("@Page_DERVRWPG", txt_page_DERVRWPG.Text);
ht.Add("@Mortgage_Information_RE01TEXT", txt_mortgage_information_RE01TEXT.Text);
ht.Add("@Mortgage_Information_RE02TEXT", txt_mortgage_information_RE02TEXT.Text);
ht.Add("@T24_Month_chain_verbiage_RE03TEXT", txt_24month_chain_RE03TEXT.Text);
ht.Add("@Tax_verbiage_EX01TEXT", txt_Tax_verbiage_EX01TEXT.Text);
//ht.Add("@Common_verbiage_EX02TEXT",txt_com);
//ht.Add("@Common_Legal_Verbiage_EX03TEXT","");
//ht.Add("@Easements_Verbiage_EX04TEXT","");
//ht.Add("@CCR_Verbiage_EX06TEXT","");
//ht.Add("@Taxes_verbiage_EX07TEXT","");
dt = dataaccess.ExecuteSP("Sp_Order_Pxt_Format", ht);
MessageBox.Show("Record Updated Successfully");
CleanForm();
}
}
}