예제 #1
0
        public int Insert(RoleInfo role)
        {
            int roleId = Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInRole(role), StoredProcedureEnum.sp_Insert_Role.ToString(), CommandType.StoredProcedure));

            foreach (var item in role.Modules)
            {
                _sqlHelper.ExecuteScalerObj(SetValuesInModule(item, roleId), StoredProcedureEnum.sp_Insert_Role_Module.ToString(), CommandType.StoredProcedure);
            }

            return(roleId);
        }
예제 #2
0
 public Int32 Insert_ContactPersonMaster(ContactPersonInfo ContPerInfo)
 {
     return(Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_ContactPersonMaster(ContPerInfo), StoredProcedureEnum.sp_Insert_ContactPersonMaster.ToString(), CommandType.StoredProcedure)));
 }
예제 #3
0
        public int Insert_CompanyMaster(CompanyInfo CompanyMaster)
        {
            int CompanyMasterId = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(SetValuesCompanyMaster(CompanyMaster), StoredProcedureEnum.sp_Save_CompanyMaster.ToString(), CommandType.StoredProcedure));

            return(CompanyMasterId);
        }
예제 #4
0
 public int Insert(DepartmentInfo departmentInfo)
 {
     return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesIndepartmentInfo(departmentInfo), StoredProcedureEnum.sp_Insert_Department.ToString(), CommandType.StoredProcedure)));
 }
예제 #5
0
 public Int32 Insert_AddressMaster(AddressInfo AddInfo)
 {
     return(Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_AddressMaster(AddInfo), StoredProcedureEnum.sp_Insert_AddressMaster.ToString(), CommandType.StoredProcedure)));
 }
예제 #6
0
 public int Insert(BankInfo bankInfo)
 {
     return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInbankInfo(bankInfo), StoredProcedureEnum.sp_Insert_Bank.ToString(), CommandType.StoredProcedure)));
 }
예제 #7
0
 public int Insert_CityMaster(CityInfo city)
 {
     return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInCity(city), StoredProcedureEnum.sp_Insert_City.ToString(), CommandType.StoredProcedure)));
 }
예제 #8
0
 public int Insert(CountryInfo country)
 {
     return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInCountry(country), StoredProcedureEnum.sp_Insert_Country.ToString(), CommandType.StoredProcedure)));
 }
예제 #9
0
 public int Insert(WarehouseInfo WarhouseInfo)
 {
     return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInWarehouseInfo(WarhouseInfo), StoredProcedureEnum.sp_Insert_Warehouse.ToString(), CommandType.StoredProcedure)));
 }
예제 #10
0
 public int Insert(SubcategoryInfo subcategory)
 {
     return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInSubcategory(subcategory), StoredProcedureEnum.sp_Insert_Subcategory.ToString(), CommandType.StoredProcedure)));
 }
예제 #11
0
 public int Insert_UserMaster(UserInfo _userInfo)
 {
     return(Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_UserMaster(_userInfo), StoredProcedureEnum.sp_Insert_UserMaster.ToString(), CommandType.StoredProcedure)));
 }
예제 #12
0
 public int Insert_StateMaster(StateInfo state)
 {
     return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInState(state), StoredProcedureEnum.sp_Insert_State.ToString(), CommandType.StoredProcedure)));
 }