public static bool CreateUpdateOwner(ManageOwnerViewModel model)
{
ManageOwnerEntity entity = new ManageOwnerEntity();
entity.OwnerAddress = new OwnerAddressEntity();
entity.OwnerBankDetails = new OwnerBankDetailEntity();
entity.OwnerId = model.OwnerId;
entity.OwnerName = model.OwnerName;
entity.ContactNo = model.ContactNumber;
entity.GSTNo = model.GSTNumber;
entity.Juridication = model.Juridication;
entity.BusinessType = model.BusiniessType;
if (model.OwnerAddresses != null)
{
foreach (var item in model.OwnerAddresses.AddressList)
{
entity.OwnerAddress.AddressList.Add(new OwnerAddressEntity()
{
Street1 = item.Street1,
City = item.City,
Id = item.Id,
PostCode = item.PostCode,
StateId = item.StateId,
Street2 = item.Street2,
IsCreated = item.IsCreated,
IsUpdated = item.IsUpdated
});
}
}
if (model.OwnerBank != null)
{
foreach (var item in model.OwnerBank.OwnerBankList)
{
entity.OwnerBankDetails.OwnerBankList.Add(new OwnerBankDetailEntity()
{
AccountNumber = item.AccountNumber,
BankName = item.BankName,
Branch = item.Branch,
Id = item.Id,
IFSC = item.IFSC,
IsCreated = item.IsCreated,
IsUpdated = item.IsUpdated
});
}
}
return(OwnerService.CreateUpdateOwner(entity));
}
public static bool CreateUpdateOwner(ManageOwnerEntity response)
{
try
{
DataTable AddressTable = UserDefinedDataTable.AddressDataTable();
foreach (var item in response.OwnerAddress.AddressList)
{
AddressTable.Rows.Add(item.Id, item.Street1, item.Street2, item.City, item.PostCode, item.StateId, response.OwnerId, item.IsCreated, item.IsUpdated);
}
DataTable BankTable = UserDefinedDataTable.BankDataTable();
foreach (var item in response.OwnerBankDetails.OwnerBankList)
{
BankTable.Rows.Add(item.Id, item.BankName, item.Branch, item.AccountNumber, item.IFSC, response.OwnerId, item.IsCreated, item.IsCreated);
}
//con.Open();
SqlParameter[] values =
{
new SqlParameter("@OwnerId", response.OwnerId),
new SqlParameter("@OwnerName", response.OwnerName),
new SqlParameter("@ContactNo", response.ContactNo),
new SqlParameter("@GSTNo", response.GSTNo),
new SqlParameter("@Juridication", response.Juridication),
new SqlParameter("@BusinessType", response.BusinessType),
new SqlParameter("@OwnerAddresses", AddressTable),
new SqlParameter("@OwnerBankDetails", BankTable)
};
var ds = SqlHelper.ExecuteSp("USP_CreateUpdateOwner", values);
return(ds > 0);
}
catch (Exception ex)
{
ApplicationCommon.WriteLog(ex.Message);
}
return(false);
}
public static ManageOwnerEntity GetOwnerById(int OwnerID)
{
ManageOwnerEntity entity = new ManageOwnerEntity();
entity.OwnerAddress = new OwnerAddressEntity();
entity.OwnerBankDetails = new OwnerBankDetailEntity();
try
{
SqlParameter[] values =
{
new SqlParameter("@OwnerId", OwnerID)
};
var ds = SqlHelper.GetResultSet("USP_GetOwnerById", values);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
entity.OwnerId = Convert.ToInt32(ds.Tables[0].Rows[i]["Id"].ToString());
entity.OwnerName = ds.Tables[0].Rows[i]["OwnerName"].ToString();
entity.ContactNo = Convert.ToInt64(ds.Tables[0].Rows[i]["ContactNo"].ToString());
entity.GSTNo = ds.Tables[0].Rows[i]["GSTNo"].ToString();
entity.Juridication = ds.Tables[0].Rows[i]["Juridication"].ToString();
entity.BusinessType = ds.Tables[0].Rows[i]["BusinessType"].ToString();
}
}
if (ds.Tables[1].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
entity.OwnerAddress.AddressList.Add(new OwnerAddressEntity()
{
Id = Convert.ToInt32(ds.Tables[1].Rows[i]["Id"].ToString()),
Street1 = ds.Tables[1].Rows[i]["Street1"].ToString(),
Street2 = ds.Tables[1].Rows[i]["Street2"].ToString(),
City = ds.Tables[1].Rows[i]["City"].ToString(),
PostCode = Convert.ToInt32(ds.Tables[1].Rows[i]["PostCode"].ToString()),
StateId = Convert.ToInt32(ds.Tables[1].Rows[i]["StateId"].ToString()),
});
}
}
if (ds.Tables[2].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[2].Rows.Count; i++)
{
entity.OwnerBankDetails.OwnerBankList.Add(new OwnerBankDetailEntity()
{
Id = Convert.ToInt32(ds.Tables[2].Rows[i]["Id"].ToString()),
BankName = ds.Tables[2].Rows[i]["BankName"].ToString(),
Branch = ds.Tables[2].Rows[i]["BranchName"].ToString(),
AccountNumber = Convert.ToInt64(ds.Tables[2].Rows[i]["AccountNumber"].ToString()),
IFSC = ds.Tables[2].Rows[i]["IFSCCode"].ToString()
});
}
}
}
catch (Exception ex)
{
ApplicationCommon.WriteLog(ex.Message);
}
return(entity);
}
