protected void btnimportNext_Click(object sender, EventArgs e)
{
CustomProfile profile = CustomProfile.GetProfile();
ImportServiceClient Import = new ImportServiceClient();
DataSet ds = new DataSet();
DataSet Importvalue = new DataSet();
Importvalue = (DataSet)Session["ImportValues"];
ds = Import.ValidateImportData(hdnobject.Value, profile.Personal.UserID, profile.Personal.CompanyID, Importvalue);
GVImportView.DataSource = ds;
GVImportView.DataBind();
if (Validate != "")
{
lblbackMessage.Text = "Colored Row Data is not valid, Please Check Remark and Click on Back button.";
btnnext.Enabled = false;
btnnext.CssClass = "class1";
}
else
{
lblOkMessage.Text = "All data are verified.Please click on Next Button ";
btnnext.Enabled = true;
lblbackMessage.Visible = false;
btnnext.CssClass = "class2";
}
// Up_PnlGirdProduct.Visible = false;
// UpdateGirdProductProcess.Visible = false;
Import.Close();
pnlImport.Visible = false;
pnlvalidate.Visible = true;
}
protected void btnimportcancel_Click(object sender, EventArgs e)
{
CustomProfile profile = CustomProfile.GetProfile();
ImportServiceClient Import = new ImportServiceClient();
Import.DeleteFromtempTable(hdnobject.Value, profile.Personal.UserID);
Import.Close();
}
protected void btnback_Click(object sender, EventArgs e)
{
CustomProfile profile = CustomProfile.GetProfile();
ImportServiceClient Import = new ImportServiceClient();
Import.DeleteFromtempTable(hdnobject.Value, profile.Personal.UserID);
pnlvalidate.Visible = false;
pnlImport.Visible = true;
btnnext.Enabled = true;
Import.Close();
}
protected RegistryAddViewModel()
{
WorkSheetsInBook = new ObservableCollection <SheetInfo>();
ImportService = new ImportServiceClient();
ImportService.GoodColumnsCompleted += ImportService_GoodColumnsCompleted;
ImportService.ClientsCompleted += ImportService_ClientsCompleted;
ImportService.ImportTypesCompleted += ImportService_ImportTypesCompleted;
ImportService.AddColumnHeadersCompleted += ImportService_AddColumnHeadersCompleted;
ImportService.GoodColumnsAsync();
ImportService.ClientsAsync();
ImportService.ImportTypesAsync();
}
protected void btnnext_Click(object sender, EventArgs e)
{
CustomProfile profile = CustomProfile.GetProfile();
ImportServiceClient Import = new ImportServiceClient();
DataSet DSInsert = new DataSet();
pnlImport.Visible = false;
pnlvalidate.Visible = false;
pnlfinish.Visible = true;
DSInsert = (DataSet)Session["ImportValues"];
long Result = Import.InsertImportLocation(hdnobject.Value, profile.Personal.UserID, profile.Personal.CompanyID, DSInsert);
Import.DeleteFromtempTable(hdnobject.Value, profile.Personal.UserID);
Import.Close();
}
protected void btnUploadPo_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
DataSet ImportData = new DataSet();
string connString = "";
CustomProfile profile = CustomProfile.GetProfile();
ImportServiceClient Import = new ImportServiceClient();
Import.DeleteFromtempTable(hdnobject.Value, profile.Personal.UserID);
Import.Close();
string path = FileuploadPO.PostedFile.FileName;
string strFileType = System.IO.Path.GetExtension(path).ToString().ToLower();
string Fullpath = Server.MapPath("../CommonControls/ImportFiles/" + path);
// string Fullpath = "https://testoms.gwclogistics.com/GWCTestVersion2/PowerOnRent/OrderImport/1DirectOrderImportTest.xlsx";
FileuploadPO.PostedFile.SaveAs(Server.MapPath("../CommonControls/ImportFiles/" + path));
if (strFileType.Trim() == ".xls")
{
connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Fullpath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
}
else if (strFileType.Trim() == ".xlsx")
{
connString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Fullpath + ";Extended Properties='Excel 8.0;HDR=Yes'";
}
OleDbConnection excelConnection = new OleDbConnection(connString);
OleDbCommand cmd1 = new OleDbCommand("Select * from [Sheet1$]", excelConnection);
OleDbDataAdapter oda = new OleDbDataAdapter();
excelConnection.Open();
oda.SelectCommand = cmd1;
oda.Fill(ImportData);
Session.Add("ImportValues", ImportData);
excelConnection.Close();
btnimpnext.Enabled = true;
btnimpnext.CssClass = "class2";
//btnimportNext.Enabled = true;
//btnimportNext.CssClass = "class2";
uploadMessage.Visible = true;
lblmessagesuccess.Visible = true;
}
public void GetImportheadData(string Object)
{
CustomProfile profile = CustomProfile.GetProfile();
ImportServiceClient Import = new ImportServiceClient();
long CompanyID = 0;
long UserID = 0;
CompanyID = profile.Personal.CompanyID;
UserID = profile.Personal.UserID;
DataSet ds = Import.GetTemplateDataByObject(Object, UserID);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
lbltext1.Text = ds.Tables[0].Rows[0]["Instruction"].ToString();
downloadlink.HRef = ds.Tables[0].Rows[0]["Template"].ToString();
}
ds.Clear();
}
/// <summary>
/// Preparing objects of type <see cref="ServiceWSDL.Person" /> and invokes method <c>DoImport()</c> from <see cref="ServiceWSDL" /> for each of them.
/// </summary>
/// <param name="repository">Received database data.</param>
public void DoImport(IFullInfoRepository repository)
{
ImportServiceClient client = new ImportServiceClient();
foreach (var p in repository.PersonRepository.PersonList)
{
Models.Address currentAddress = repository.AddressRepository.AddressList.First(a => a.Id == p.AddressId);
Models.Agreement currentAgreement = repository.AgreementRepository.AgreementList.First(a => a.PersonId == p.Id);
Models.FinancialState currentFinancialState = repository.FinancialStateRepository.FinancialStateList.First(a => a.Id == currentAgreement.FinancialStateId);
client.DoImport(new Person()
{
Name = p.FirstName,
Surname = p.Surname,
Addresses = new Address[]
{
new Address()
{
AddressType = "Main",
City = currentAddress.PostOfficeCity,
Street = currentAddress.StreetName,
HouseNo = currentAddress.StreetNumber,
LocaleNo = currentAddress.FlatNumber,
PostalCode = currentAddress.PostCode
},
new Address()
{
AddressType = "Correspondence",
City = currentAddress.CorrespondencePostOfficeCity,
Street = currentAddress.CorrespondenceStreetName,
HouseNo = currentAddress.CorrespondenceStreetNumber,
LocaleNo = currentAddress.CorrespondenceFlatNumber,
PostalCode = currentAddress.CorrespondencePostCode
}
},
FinancialState = new FinancialState()
{
Capital = currentFinancialState.OutstandingLiabilities,
Interest = currentFinancialState.Interests,
PenaltyInterest = currentFinancialState.PenaltyInterests,
Fees = currentFinancialState.Fees == null ? 0 : (decimal)currentFinancialState.Fees,
CourtFees = currentFinancialState.CourtFees,
CourtRepresentationFees = currentFinancialState.RepresentationCourtFees == null ? 0 : (decimal)currentFinancialState.RepresentationCourtFees,
EnforcementFees = currentFinancialState.VindicationCosts == null ? 0 : (decimal)currentFinancialState.VindicationCosts,
EnforcementRepresentationFees = currentFinancialState.RepresentationVindicationCosts == null ? 0 : (decimal)currentFinancialState.RepresentationVindicationCosts
},
NationalIdentificationNumber = p.NationalIdentificationNumber,
Phones = new Phone[]
{
//There is no properties to write in, for ServiceWSDL.Phone
new Phone()
{
//Phone 1
},
new Phone()
{
//Phone 2
}
},
IdentityDocuments = new IdentityDocument[]
{
new IdentityDocument()
{
Type = "PESEL",
ExpirationDate = new DateTime(),
Number = p.NationalIdentificationNumber
}
}
});
}
}
protected RegistryAddViewModel()
{
WorkSheetsInBook = new ObservableCollection<SheetInfo>();
ImportService = new ImportServiceClient();
ImportService.GoodColumnsCompleted += ImportService_GoodColumnsCompleted;
ImportService.ClientsCompleted += ImportService_ClientsCompleted;
ImportService.ImportTypesCompleted += ImportService_ImportTypesCompleted;
ImportService.AddColumnHeadersCompleted += ImportService_AddColumnHeadersCompleted;
ImportService.GoodColumnsAsync();
ImportService.ClientsAsync();
ImportService.ImportTypesAsync();
}
