public int Save(CLayer.UserFiles file) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pFileId", DataPlug.DataType._BigInt, file.FileId)); param.Add(Connection.GetParameter("pFileName", DataPlug.DataType._Varchar, file.FileName)); param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, file.UserId)); param.Add(Connection.GetParameter("pDocument", DataPlug.DataType._Int, file.Document)); object result = Connection.ExecuteQueryScalar("userfiles_Save", param); return(Connection.ToInteger(result)); }
public CLayer.UserFiles GetOnUserAndType(long UserId, int Type) { CLayer.UserFiles file = null; DataTable dt = Connection.GetSQLTable("SELECT * FROM userfiles WHERE UserId=" + UserId.ToString() + " AND Document=" + Type.ToString()); if (dt.Rows.Count > 0) { file = new CLayer.UserFiles(); file.FileId = Connection.ToLong(dt.Rows[0]["FileId"]); file.FileName = Connection.ToString(dt.Rows[0]["FileName"]); file.UserId = Connection.ToLong(dt.Rows[0]["UserId"]); file.Document = Connection.ToInteger(dt.Rows[0]["Document"]); } return(file); }
public CLayer.UserFiles Get(long fileId) { CLayer.UserFiles file = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pFileId", DataPlug.DataType._BigInt, fileId)); DataTable dt = Connection.GetTable("userfiles_Get", param); if (dt.Rows.Count > 0) { file = new CLayer.UserFiles(); file.FileId = Connection.ToLong(dt.Rows[0]["FileId"]); file.FileName = Connection.ToString(dt.Rows[0]["FileName"]); file.UserId = Connection.ToLong(dt.Rows[0]["UserId"]); file.Document = Connection.ToInteger(dt.Rows[0]["Document"]); } return(file); }
private void Save(Models.UserDocumentsModel data) { #region Bank Account details for Supplier if (data.UserType == (int)CLayer.Role.Roles.Supplier) { string b2bname = BLayer.B2BUser.Getb2bname(data.UserId); if (data.BankName != "") { CLayer.BankAccount account = new CLayer.BankAccount() { BankAccountId = data.BankAccountId, UserId = data.UserId, AccountName = b2bname,// data.Name,//Business name b2b AccountNumber = data.AccountNumber, BankName = data.BankName, BranchAddress = data.BranchAddress, RTGSNumber = data.RTGSNumber, MICRCode = data.MICRCode }; BLayer.BankAccount.Save(account); } } if (data.UserType == (int)CLayer.Role.Roles.Affiliate) { string b2bname = BLayer.B2BUser.Getb2bname(data.UserId); if (data.BankName != "") { CLayer.BankAccount account = new CLayer.BankAccount() { BankAccountId = data.BankAccountId, UserId = data.UserId, AccountName = b2bname,// data.Name,//Business name b2b AccountNumber = data.AccountNumber, BankName = data.BankName, BranchAddress = data.BranchAddress, RTGSNumber = data.RTGSNumber, MICRCode = data.MICRCode }; BLayer.BankAccount.Save(account); } } #endregion #region File Attatchments if (data.ServiceTaxReg != null && data.ServiceTaxReg.ContentLength > 0) { CLayer.UserFiles servicetax = new CLayer.UserFiles() { UserId = data.UserId, FileId = 0, FileName = "ServiceTax" + data.UserId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss") + System.IO.Path.GetFileName(data.ServiceTaxReg.FileName), Document = (int)CLayer.UserFiles.Documents.ServiceTaxRegNo }; BLayer.UserFiles.Save(servicetax); SaveDocument(data.ServiceTaxReg, data.UserId, servicetax.FileName); } if (data.VATReg != null && data.VATReg.ContentLength > 0) { CLayer.UserFiles vat = new CLayer.UserFiles() { UserId = data.UserId, FileId = 0, FileName = "VAT" + data.UserId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss") + System.IO.Path.GetFileName(data.VATReg.FileName), Document = (int)CLayer.UserFiles.Documents.VATRegNo }; BLayer.UserFiles.Save(vat); SaveDocument(data.VATReg, data.UserId, vat.FileName); } if (data.BusinessRegistrationCertificate != null && data.BusinessRegistrationCertificate.ContentLength > 0) { CLayer.UserFiles brc = new CLayer.UserFiles() { UserId = data.UserId, FileId = 0, FileName = "BRC" + data.UserId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss") + System.IO.Path.GetFileName(data.BusinessRegistrationCertificate.FileName), Document = (int)CLayer.UserFiles.Documents.BusinessRegistrationCertificate }; BLayer.UserFiles.Save(brc); SaveDocument(data.BusinessRegistrationCertificate, data.UserId, brc.FileName); } if (data.PANCard != null && data.PANCard.ContentLength > 0) { CLayer.UserFiles pan = new CLayer.UserFiles() { UserId = data.UserId, FileId = 0, FileName = "PAN" + data.UserId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss") + System.IO.Path.GetFileName(data.PANCard.FileName), Document = (int)CLayer.UserFiles.Documents.PANCard }; BLayer.UserFiles.Save(pan); SaveDocument(data.PANCard, data.UserId, pan.FileName); } if (data.CorporateLogo != null && data.CorporateLogo.ContentLength > 0) { CLayer.UserFiles corporatelogo = new CLayer.UserFiles() { UserId = data.UserId, FileId = 0, FileName = "CORPORATELOGO" + data.UserId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss") + System.IO.Path.GetFileName(data.CorporateLogo.FileName), Document = (int)CLayer.UserFiles.Documents.CorporateLogo }; BLayer.UserFiles.Save(corporatelogo); SaveDocument(data.CorporateLogo, data.UserId, corporatelogo.FileName); } if (data.CopyOfCheque != null && data.CopyOfCheque.ContentLength > 0) { CLayer.UserFiles cc = new CLayer.UserFiles() { UserId = data.UserId, FileId = 0, FileName = "Cheque" + data.UserId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss") + System.IO.Path.GetFileName(data.CopyOfCheque.FileName), Document = (int)CLayer.UserFiles.Documents.CopyOfCheque }; BLayer.UserFiles.Save(cc); SaveDocument(data.CopyOfCheque, data.UserId, cc.FileName); } #endregion //#region File Attatchments //if (data.ServiceTaxReg != null) //{ // CLayer.UserFiles servicetax = new CLayer.UserFiles() // { // UserId = data.UserId, // FileId = 0, // FileName = data.UserId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss") + System.IO.Path.GetFileName(data.ServiceTaxReg.FileName), // Document = (int)CLayer.UserFiles.Documents.ServiceTaxRegNo // }; // BLayer.UserFiles.Save(servicetax); // SaveDocument(data.ServiceTaxReg, data.UserId, servicetax.FileName); //} //if (data.VATReg != null) //{ // CLayer.UserFiles vat = new CLayer.UserFiles() // { // UserId = data.UserId, // FileId = 0, // FileName = data.UserId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss") + System.IO.Path.GetFileName(data.VATReg.FileName), // Document = (int)CLayer.UserFiles.Documents.VATRegNo // }; // BLayer.UserFiles.Save(vat); // SaveDocument(data.VATReg, data.UserId, vat.FileName); //} //if (data.BusinessRegistrationCertificate != null) //{ // CLayer.UserFiles brc = new CLayer.UserFiles() // { // UserId = data.UserId, // FileId = 0, // FileName = data.UserId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss") + System.IO.Path.GetFileName(data.BusinessRegistrationCertificate.FileName), // Document = (int)CLayer.UserFiles.Documents.BusinessRegistrationCertificate // }; // BLayer.UserFiles.Save(brc); // SaveDocument(data.BusinessRegistrationCertificate, data.UserId, brc.FileName); //} //if (data.PANCard != null) //{ // CLayer.UserFiles pan = new CLayer.UserFiles() // { // UserId = data.UserId, // FileId = 0, // FileName = data.UserId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss") + System.IO.Path.GetFileName(data.PANCard.FileName), // Document = (int)CLayer.UserFiles.Documents.PANCard // }; // BLayer.UserFiles.Save(pan); // SaveDocument(data.PANCard, data.UserId, pan.FileName); //} //if (data.CopyOfCheque != null) //{ // CLayer.UserFiles cc = new CLayer.UserFiles() // { // UserId = data.UserId, // FileId = 0, // FileName = data.UserId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss") + System.IO.Path.GetFileName(data.CopyOfCheque.FileName), // Document = (int)CLayer.UserFiles.Documents.CopyOfCheque // }; // BLayer.UserFiles.Save(cc); // SaveDocument(data.CopyOfCheque, data.UserId,cc.FileName); //} //#endregion }
public static int Save(CLayer.UserFiles file) { DataLayer.UserFiles pf = new DataLayer.UserFiles(); file.Validate(); return(pf.Save(file)); }
private void Save2(Models.SupplierB2BModel data) { string tempName = ""; if (data.UserType != (int)CLayer.Role.Roles.Agent) { if (data.ContactName == null) { tempName = data.Name.TrimStart();//Business Name } else { tempName = data.ContactName.TrimStart();// Name } } else { tempName = data.ContactName.TrimStart(); } string tFirstName = tempName; string tLastName = ""; if (data.UserType == (int)CLayer.Role.Roles.Supplier) { tFirstName = tempName; tLastName = tempName; } else if (data.UserType == (int)CLayer.Role.Roles.Corporate) { tFirstName = tempName; tLastName = tempName; } else if (data.UserType == (int)CLayer.Role.Roles.Agent) { tFirstName = tempName; tLastName = tempName; } else { // tFirstName = data.ContactName.TrimStart(); // tLastName = data.ContactName.TrimStart(); //--- int firstspace = tempName.IndexOf(' '); if (firstspace > 1) { if (firstspace < data.ContactName.Length - 1) { tFirstName = tempName.Split(' ')[0].ToString(); tLastName = tempName.Substring(firstspace + 1, tempName.Length - tFirstName.Length - 1); } } //---- } CLayer.User usr = new CLayer.User() { SalutationId = 1, FirstName = tFirstName, LastName = "", Email = data.Email, UserTypeId = data.UserType, Status = (int)CLayer.ObjectStatus.StatusType.NotVerified }; long UsrId = BLayer.User.Save(usr); CLayer.B2B b2b = new CLayer.B2B() { B2BId = UsrId, Name = data.Name,//Business Name ServiceTaxRegNo = data.ServiceTaxRegNo, PANNo = data.PANNo, VATRegNo = data.VATRegNo }; if (data.UserType == (int)CLayer.Role.Roles.Supplier) { b2b.PropertyDescription = data.PropertyDescription; b2b.AvailableProperties = data.AvailableProperties; } data.B2BId = BLayer.B2B.Save(b2b); CLayer.Address address = new CLayer.Address() { AddressId = 0, UserId = UsrId, AddressText = data.Address, CityId = data.CityId, State = data.State, CountryId = data.CountryId, ZipCode = data.ZipCode, Phone = data.Phone, Mobile = data.Mobile, AddressType = (int)CLayer.Address.AddressTypes.Primary }; if (data.City != null && data.City != "") { address.City = data.City; } if (data.CityId > 0) { address.City = BLayer.City.Get(data.CityId).Name; } address.AddressType = (int)CLayer.Address.AddressTypes.Primary; BLayer.Address.Save(address); #region Billing Address For Corporate have to be here before "save" line of the address object if (data.UserType == (int)CLayer.Role.Roles.Corporate) { if (data.BillingAddress != "") { CLayer.Address billingaddress = new CLayer.Address() { AddressId = 0, UserId = UsrId, AddressText = data.BillingAddress, CityId = data.BillingCityId, State = data.BillingState, CountryId = data.BillingCountryId, ZipCode = "", Phone = "", Mobile = "", AddressType = (int)CLayer.Address.AddressTypes.Primary }; if (data.BillingCity != null && data.BillingCity != "") { billingaddress.City = data.BillingCity; } if (data.BillingCityId > 0) { billingaddress.City = BLayer.City.Get(data.BillingCityId).Name; } BLayer.Address.Save(billingaddress); } } #endregion #region Bank Account details for Supplier if (data.UserType == (int)CLayer.Role.Roles.Supplier) { if (data.BankName != "") { CLayer.BankAccount account = new CLayer.BankAccount() { BankAccountId = 0, UserId = UsrId, AccountName = data.Name,//Business name AccountNumber = data.AccountNumber, BankName = data.BankName, BranchAddress = data.BranchAddress, RTGSNumber = data.RTGSNumber, MICRCode = data.MICRCode }; BLayer.BankAccount.Save(account); } } #endregion #region File Attatchments if (data.ServiceTaxReg != null) { CLayer.UserFiles servicetax = new CLayer.UserFiles() { UserId = UsrId, FileId = 0, FileName = UsrId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss") + System.IO.Path.GetFileName(data.ServiceTaxReg.FileName), Document = (int)CLayer.UserFiles.Documents.ServiceTaxRegNo }; BLayer.UserFiles.Save(servicetax); SaveDocument(data.ServiceTaxReg, UsrId, servicetax.FileName); } if (data.VATReg != null) { CLayer.UserFiles vat = new CLayer.UserFiles() { UserId = UsrId, FileId = 0, FileName = UsrId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss") + System.IO.Path.GetFileName(data.VATReg.FileName), Document = (int)CLayer.UserFiles.Documents.VATRegNo }; BLayer.UserFiles.Save(vat); SaveDocument(data.VATReg, UsrId, vat.FileName); } if (data.BusinessRegistrationCertificate != null) { CLayer.UserFiles brc = new CLayer.UserFiles() { UserId = UsrId, FileId = 0, FileName = UsrId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss") + System.IO.Path.GetFileName(data.BusinessRegistrationCertificate.FileName), Document = (int)CLayer.UserFiles.Documents.BusinessRegistrationCertificate }; BLayer.UserFiles.Save(brc); SaveDocument(data.BusinessRegistrationCertificate, UsrId, brc.FileName); } if (data.PANCard != null) { CLayer.UserFiles pan = new CLayer.UserFiles() { UserId = UsrId, FileId = 0, FileName = UsrId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss") + System.IO.Path.GetFileName(data.PANCard.FileName), Document = (int)CLayer.UserFiles.Documents.PANCard }; BLayer.UserFiles.Save(pan); SaveDocument(data.PANCard, UsrId, pan.FileName); } if (data.CopyOfCheque != null) { CLayer.UserFiles cc = new CLayer.UserFiles() { UserId = UsrId, FileId = 0, FileName = UsrId.ToString() + DateTime.Now.ToString("ddMMyyyyHHmmss") + System.IO.Path.GetFileName(data.CopyOfCheque.FileName), Document = (int)CLayer.UserFiles.Documents.CopyOfCheque }; BLayer.UserFiles.Save(cc); SaveDocument(data.CopyOfCheque, UsrId, cc.FileName); } #endregion }