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); }