public long Save(CLayer.BankAccount data)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pBankAccountId", DataPlug.DataType._BigInt, data.BankAccountId));
param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, data.UserId));
param.Add(Connection.GetParameter("pAccountName", DataPlug.DataType._Varchar, data.AccountName));
param.Add(Connection.GetParameter("pAccountNumber", DataPlug.DataType._Varchar, data.AccountNumber));
param.Add(Connection.GetParameter("pBankName", DataPlug.DataType._Varchar, data.BankName));
param.Add(Connection.GetParameter("pBranchAddress", DataPlug.DataType._Varchar, data.BranchAddress));
param.Add(Connection.GetParameter("pRTGSNumber", DataPlug.DataType._Varchar, data.RTGSNumber));
param.Add(Connection.GetParameter("pMIRCCode", DataPlug.DataType._Varchar, data.MICRCode));
object result = Connection.ExecuteQueryScalar("bankaccount_Save", param);
return(Connection.ToInteger(result));
}
public CLayer.BankAccount GetOnUser(long UserId)
{
CLayer.BankAccount result = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, UserId));
DataTable dt = Connection.GetTable("bankaccount_GetOnUser", param);
if (dt.Rows.Count > 0)
{
result = new CLayer.BankAccount()
{
BankAccountId = Connection.ToLong(dt.Rows[0]["BankAccountId"]),
UserId = Connection.ToLong(dt.Rows[0]["UserId"]),
AccountName = Connection.ToString(dt.Rows[0]["AccountName"]),
AccountNumber = Connection.ToString(dt.Rows[0]["AccountNumber"]),
BankName = Connection.ToString(dt.Rows[0]["BankName"]),
BranchAddress = Connection.ToString(dt.Rows[0]["BranchAddress"]),
RTGSNumber = Connection.ToString(dt.Rows[0]["RTGSNumber"]),
MICRCode = Connection.ToString(dt.Rows[0]["MIRCCode"])
};
}
return(result);
}
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
}
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
}
public static long Save(CLayer.BankAccount data)
{
DataLayer.BankAccount bankaccount = new DataLayer.BankAccount();
data.Validate();
return(bankaccount.Save(data));
}
