public bool Save <T>(T item) where T : IContract { var result = 0; var branch = (Branch)(object)item; if (currentTransaction == null) { connection = db.CreateConnection(); connection.Open(); } var transaction = (currentTransaction == null ? connection.BeginTransaction() : currentTransaction); try { var savecommand = db.GetStoredProcCommand(DBRoutine.SAVEBRANCH); db.AddInParameter(savecommand, "BranchID", System.Data.DbType.Int16, branch.BranchID); db.AddInParameter(savecommand, "BranchCode", System.Data.DbType.String, branch.BranchCode); db.AddInParameter(savecommand, "BranchName", System.Data.DbType.String, branch.BranchName); db.AddInParameter(savecommand, "RegNo", System.Data.DbType.String, branch.RegNo); db.AddInParameter(savecommand, "IsActive", System.Data.DbType.Boolean, branch.IsActive); db.AddInParameter(savecommand, "CompanyCode", System.Data.DbType.String, branch.CompanyCode); db.AddInParameter(savecommand, "CreatedBy", System.Data.DbType.String, branch.CreatedBy); db.AddInParameter(savecommand, "ModifiedBy", System.Data.DbType.String, branch.ModifiedBy); result = db.ExecuteNonQuery(savecommand, transaction); if (result > 0) { AddressDAL addressDAL = new AddressDAL(); branch.BranchAddress.CreatedBy = branch.CreatedBy; branch.BranchAddress.ModifiedBy = branch.ModifiedBy; branch.BranchAddress.AddressLinkID = branch.BranchCode; result = addressDAL.Save(branch.BranchAddress, transaction) == true ? 1 : 0; } if (result > 0) { transaction.Commit(); } else { transaction.Rollback(); } } catch (Exception) { transaction.Rollback(); throw; } return(result > 0 ? true : false); }
public Address GetCompanyAddress(Company companyItem) { var contactItem = new Address { AddressLinkID = companyItem.CompanyCode, AddressType = "Company" }; var currentAddress = new AddressDAL().GetContactsByCustomer(contactItem).FirstOrDefault(); //companyItem.ContactItem = new ContactDAL().GetItem(contactItem); return(currentAddress); }
public bool Save <T>(T item) where T : IContract { var result = 0; var company = (Company)(object)item; if (currentTransaction == null) { connection = db.CreateConnection(); connection.Open(); } var transaction = (currentTransaction == null ? connection.BeginTransaction() : currentTransaction); try { var savecommand = db.GetStoredProcCommand(DBRoutine.SAVECOMPANY); db.AddInParameter(savecommand, "CompanyCode", System.Data.DbType.String, company.CompanyCode); db.AddInParameter(savecommand, "CompanyName", System.Data.DbType.String, company.CompanyName); db.AddInParameter(savecommand, "RegNo", System.Data.DbType.String, company.RegNo); //db.AddInParameter(savecommand, "Logo", System.Data.DbType.Object, company.Logo); db.AddInParameter(savecommand, "IsActive", System.Data.DbType.Boolean, company.IsActive); db.AddInParameter(savecommand, "CreatedBy", System.Data.DbType.String, company.CreatedBy); db.AddInParameter(savecommand, "ModifiedBy", System.Data.DbType.String, company.ModifiedBy); result = db.ExecuteNonQuery(savecommand, transaction); if (result > 0) { AddressDAL addressDAL = new AddressDAL(); company.CompanyAddress.CreatedBy = company.CreatedBy; company.CompanyAddress.ModifiedBy = company.ModifiedBy; company.CompanyAddress.AddressLinkID = company.CompanyCode; result = addressDAL.Save(company.CompanyAddress, transaction) == true ? 1 : 0; } if (result > 0) { if (currentTransaction == null) { transaction.Commit(); } } else { if (currentTransaction == null) { transaction.Rollback(); } } } catch (Exception ex) { if (currentTransaction == null) { transaction.Rollback(); } throw ex; } return(result > 0 ? true : false); }