public IHttpActionResult Put(BatchMaster batchMaster, int batchMasterId = 0) { OperationStatus operationStatus = new OperationStatus() { ServiceMethod = "PUT", ServiceName = "UpdateBatchMaster", RequestProcessed = false, RequestSuccessful = false }; if (batchMaster != null) { if (batchMasterId > 0) { //Comment : Here set value of batchMasterId into DTO object and then call Update method batchMaster.Id = batchMasterId; operationStatus = GetBatchMasterDbService().UpdateBatchMaster(batchMaster); } else { operationStatus.Messages.Add(new Message() { DTOName = "BatchMaster", DTOProperty = "", MessageType = MessageType.SystemError, Text = "Please use POST method to create object." }); } } return(Ok(operationStatus)); }
public bool UpdateBatchMaster(BatchMaster batchMaster) { bool returnvalue = false; DynamicParameters param = new DynamicParameters(); param.Add("@BatchId", batchMaster.BatchId); param.Add("@BatchName", batchMaster.BatchName); param.Add("@ResultType", batchMaster.ResultType); param.Add("@AcademicTerm", batchMaster.AcademicTerm); param.Add("@UniversityId", batchMaster.UniversityId); param.Add("@Active", 1); param.Add("@lastupdateddt", DateTime.UtcNow); param.Add("@lastupdatedby", 1); param.Add("@BatchType", batchMaster.BatchType); _db.Open(); var val = _db.Execute("YSP_UpdateBatchMaster", param, commandType: CommandType.StoredProcedure); if (val > 0) { returnvalue = true; } _db.Close(); return(returnvalue); }
public bool InsUpdBatchMaster(int?id, BatchMaster batchMaster) { try { var obj = JsonConvert.SerializeObject (new BatchMaster { BatchId = batchMaster.BatchId, BatchName = batchMaster.BatchName, ResultType = batchMaster.ResultType, AcademicTerm = batchMaster.AcademicTerm, UserId = batchMaster.UserId, TokenId = batchMaster.TokenId }); var ChptrObj = obj.ToString(); var JsonObj = db.UpdateBatch(id, ChptrObj); return(true); //db.Entry(batchMaster).State = System.Data.Entity.EntityState.Modified; //db.SaveChanges(); //return true; } catch (Exception ex) { Console.WriteLine("NotImplementedException", ex); return(false); } }
public bool DeleteBatchMaster(int?id, BatchMaster batchMaster) { try { var obj = JsonConvert.SerializeObject (new BatchMaster { BatchId = batchMaster.BatchId, UserId = batchMaster.UserId, TokenId = batchMaster.TokenId }); var ChptrObj = obj.ToString(); var JsonObj = db.RemoveBatch(id, ChptrObj); return(true); //var batchMaster = db.BatchMasters.Where(x => x.BatchId == id).FirstOrDefault(); //if (batchMaster == null) return false; //db.Entry(batchMaster).State = System.Data.Entity.EntityState.Deleted; //db.SaveChanges(); //return true; } catch (Exception ex) { Console.WriteLine("NotImplementedException", ex); return(false); } }
private void txtPQty_KeyDown(object sender, KeyEventArgs e) { if (e.Key == Key.Enter) { SalesBillModel sbm = new SalesBillModel(); sbm.ProductName = txtProducts.Text; BatchMaster batchMaster = (BatchMaster)BatchNumberGridView.SelectedItem; sbm.BatchNo = batchMaster.BatchNo; sbm.Expiry = batchMaster.Expiry; sbm.MRP = batchMaster.MRP; sbm.Qty = Convert.ToDecimal(txtPQty.Text); salesBillViewModel.AddNewRow(sbm); SalesGridView.ItemsSource = salesBillViewModel.objSalesBillM.ListSalesBillModel; txtProducts.Text = "@"; txtPQty.Text = ""; txtTotalQty.Text = SalesBillViewModel.TotalQty.ToString(); txtTotalAmount.Text = SalesBillViewModel.TotalAmount.ToString("0.00"); batchMasterViewModel.objBatchMaster.BatchMasterListByProductCode("-1"); BatchNumberGridView.ItemsSource = batchMasterViewModel.objBatchMaster.ListBatchMaster; BatchNumberGridView.SelectedIndex = 0; txtProducts.Focus(); SalesGridView.SelectedIndex = salesBillViewModel.objSalesBillM.ListSalesBillModel.Count; //txtProducts.selections //salesBillViewModel.CurrentRow.BatchNo = batchMaster.BatchNo; //salesBillViewModel.CurrentRow.BatchNo = batchMaster.BatchNo; //salesBillViewModel.CurrentRow.BatchNo = batchMaster.BatchNo; //salesBillViewModel.CurrentRow.BatchNo = batchMaster.BatchNo; } }
static void Main(string[] args) { List <int> myIntList = new List <int>(); for (int i = 0; i < 150; i++) { myIntList.Add(i + 1); } var config = new ExecutionConfig { BatchSize = 30, BatchDelayInMS = 200 //this property will be ignored in the Parallel mode }; Console.WriteLine("Normal:"); var result = BatchMaster.Execute(myIntList, (batch) => { DoSomethingWithMyBatch(batch.ToList()); }, config); Console.WriteLine(result); Console.WriteLine("-------------------------------------"); Console.WriteLine("Parallel:"); var pResult = BatchMaster.ExecuteParallel(myIntList, (batch) => { DoSomethingWithMyBatch(batch.ToList()); }, config); Console.WriteLine(pResult); Console.ReadLine(); }
public void BatchMasterListByProductCode(string ProductCode) { BatchMaster bm = new BatchMaster(); bm.ProductCode = Convert.ToInt64(ProductCode); ListBatchMaster = new ObservableCollection <BatchMaster>(BLL.BllClient.objBllClient.GetList <BatchMaster>(Common.DataSourceTypes.BatchMasterListByProductCode, bm)); }
public void GetListBatchMasterByProductCode <T>(T objFilter, ref List <T> listData) where T : class, IModel, new() { string sQuery = "sprocGetBatchMasterByProductCode"; BatchMaster objData = objFilter as BatchMaster; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("ProductCode", "ProductCode", 8, GenericDataType.Long, ParameterDirection.Input, objData.ProductCode)); SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillBatchMasterDataFromReader, ref listData); }
private void FillBatchMasterDataFromReader <T>(DbDataReader DbReader, ref List <T> listData) where T : class, IModel, new() { while (DbReader.Read()) { T obj = new T(); BatchMaster objData = obj as BatchMaster; obj.FillDataFromDB(DbReader); listData.Add(obj); } }
public IHttpActionResult UpdateBatchMaster(BatchMaster batchMaster) { var isupdate = _batchMasterRepository.UpdateBatchMaster(batchMaster); if (isupdate == true) { return(Ok(isupdate)); } return(BadRequest()); }
public IHttpActionResult Delete(BatchMaster batchMaster) { var isDeleted = batchMasterService.DeleteBatchMaster(batchMaster.UniversityId, batchMaster); if (isDeleted == true) { return(Ok()); } return(BadRequest()); }
public IHttpActionResult Save(BatchMaster batchMaster) { var isUpdate = batchMasterService.InsUpdBatchMaster(batchMaster.UniversityId, batchMaster); if (isUpdate == true) { return(Ok()); } return(BadRequest()); }
public SalesBill(BatchMaster batchMaster) { //InitializeComponent(); //txtPacking.Text = "1 G"; //lbl.Content = "tt"; //txtCompany.Text = batchMaster.AccountCode.ToString(); //txtMRP.Text = batchMaster.MRP.ToString(); //txtBatchNo.Text = batchMaster.BatchNo; //txtExpiryDate.Text = batchMaster.Expiry.ToString(); }
OperationStatus IBatchMasterDbService.UpdateBatchMaster(BatchMaster data) { OperationStatus operationStatus = new OperationStatus() { RequestProcessed = false, RequestSuccessful = false }; #region Comment : Here Iterate all request for mapping try { #region Supply data object for DB insertion //Comment : Here record id which is being effected at db level Int32 effectedRecordId = SubmitBatchMaster(data); //if successfully executed if (effectedRecordId > 0) { //Comment : Here if data has been "successfully submitted" then capture those details operationStatus.RequestProcessed = true; operationStatus.RequestSuccessful = true; operationStatus.ServiceName = "UpdateBatchMaster"; operationStatus.ServiceMethod = "POST"; operationStatus.AffectedIds.Add(new AffectedId() { DTOName = "BatchMaster", DTOProperty = "BatchMasterId", IdValue = effectedRecordId.ToString(), OperationType = OperationType.POST }); } else { //LoggingService.Instance.Fatal(string.Format("Unable to add user :{0}{1}", Environment.NewLine, object)); } #endregion } catch (Exception ex) { operationStatus.RequestProcessed = true; operationStatus.RequestSuccessful = false; operationStatus.Messages.Add(new Message() { DTOName = "BatchMaster", DTOProperty = "", MessageType = MessageType.SystemError, Text = ex.Message }); } #endregion return(operationStatus); }
public string AddUpdateBatchMaster(RoleViewModel Model) { try { string status = ""; BatchMaster role = null; LogActivityViewModel log = new LogActivityViewModel(); log.EnteredBy = Model.EnteredBy; log.EnteredDate = DateTime.Now; log.ActioName = "AddUpdateBatchMaster"; log.ModuleName = "Control Panel"; log.ControllerName = "Admin"; if (Model.Id > 0) { role = _context.BatchMasters.Where(b => b.Id == Model.Id).FirstOrDefault(); status = "Update Successfully!"; log.Activity = "Update"; log.ActivityMessage = "'" + Model.Name + "' is updated."; } if (role == null) { role = new BatchMaster(); } role.IsActive = Model.IsActive; role.Name = Model.Name; role.DateOfStart = !string.IsNullOrEmpty(Model.BatchStartDateStr) ? (DateTime.ParseExact(Model.BatchStartDateStr, "dd/MM/yyyy", CultureInfo.InvariantCulture)) : (DateTime?)null; role.DateOfEnd = !string.IsNullOrEmpty(Model.BatchEndDateStr) ? (DateTime.ParseExact(Model.BatchEndDateStr, "dd/MM/yyyy", CultureInfo.InvariantCulture)) : (DateTime?)null; if (Model.Id == 0) { status = "Add Successfully!"; log.Activity = "Create"; log.ActivityMessage = "'" + Model.Name + "' is added."; _context.BatchMasters.Add(role); } _context.SaveChanges(); logActivityService.CreateLogActivity(log); return(status); } catch (Exception ex) { return(ex.Message); } }
public IHttpActionResult Post(BatchMaster batchMaster) { OperationStatus operationStatus = new OperationStatus() { ServiceMethod = "POST", ServiceName = "AddBatchMaster", RequestProcessed = false, RequestSuccessful = false }; if (batchMaster != null) { if (batchMaster.Id == 0) { operationStatus = GetBatchMasterDbService().AddBatchMaster(batchMaster); } else { operationStatus.Messages.Add(new Message() { DTOName = "BatchMaster", DTOProperty = "", MessageType = MessageType.SystemError, Text = "Please use PUT method to update state of object." }); } } return(Ok(operationStatus)); }
private Int32 SubmitBatchMaster(BatchMaster data) { var parameterList = new List <System.Data.IDbDataParameter> { //Batch-Master related data new SqlParameter() { ParameterName = "@BatchMasterId", Value = data.Id, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@BatchId", Value = data.BatchId, SqlDbType = SqlDbType.VarChar, Size = 10 }, new SqlParameter() { ParameterName = "@BatchName", Value = data.BatchName, SqlDbType = SqlDbType.VarChar, Size = 100 }, //Batch other details data-1 new SqlParameter() { ParameterName = "@SchemeId", Value = data.BatchDetails.SchemeId, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@JobRoleId", Value = data.BatchDetails.JobRoleId, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@CityId", Value = data.BatchDetails.CityId, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@District", Value = data.BatchDetails.District, SqlDbType = SqlDbType.VarChar, Size = 200 }, new SqlParameter() { ParameterName = "@TotalCandidates", Value = data.BatchDetails.TotalCandidates, SqlDbType = SqlDbType.Int }, //Batch other details data-2 new SqlParameter() { ParameterName = "@VTP_Id", Value = data.BatchDetails.VTP_Id, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@VTP_SPOC_Name", Value = data.BatchDetails.VTP_SPOC_Name, SqlDbType = SqlDbType.VarChar, Size = 250 }, new SqlParameter() { ParameterName = "@VTP_SPOC_Email", Value = data.BatchDetails.VTP_SPOC_Email, SqlDbType = SqlDbType.VarChar, Size = 150 }, new SqlParameter() { ParameterName = "@VTP_SPOC_Mobile", Value = data.BatchDetails.VTP_SPOC_Mobile, SqlDbType = SqlDbType.VarChar, Size = 10 }, new SqlParameter() { ParameterName = "@VTP_SPOC_Mobile2", Value = data.BatchDetails.VTP_SPOC_Mobile2, SqlDbType = SqlDbType.VarChar, Size = 10 }, new SqlParameter() { ParameterName = "@VTP_SPOC_AlternativeNo", Value = data.BatchDetails.VTP_SPOC_AlternativeNo, SqlDbType = SqlDbType.VarChar, Size = 15 }, new SqlParameter() { ParameterName = "@VTP_Address", Value = data.BatchDetails.VTP_Address, SqlDbType = SqlDbType.VarChar, Size = 500 }, new SqlParameter() { ParameterName = "@Centre_SPOC_Name", Value = data.BatchDetails.Centre_SPOC_Name, SqlDbType = SqlDbType.VarChar, Size = 250 }, new SqlParameter() { ParameterName = "@Centre_SPOC_Email", Value = data.BatchDetails.Centre_SPOC_Email, SqlDbType = SqlDbType.VarChar, Size = 150 }, new SqlParameter() { ParameterName = "@Centre_SPOC_Mobile", Value = data.BatchDetails.Centre_SPOC_Mobile, SqlDbType = SqlDbType.VarChar, Size = 10 }, //5S Params new SqlParameter() { ParameterName = "@CreatedBy", Value = data.CreatedBy, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@ModifiedBy", Value = data.ModifiedBy, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@IsActive", Value = data.IsActive, SqlDbType = SqlDbType.Bit }, new SqlParameter() { ParameterName = "BatchMasterId", SqlDbType = SqlDbType.Int, Direction = ParameterDirection.ReturnValue } }; //Comment : Here get DbConnector object var rowEffeted = GetDbConnector().ExecuteNonQuery("MaintainBatchMaster", QueryCommandType.StoredProcedure, parameterList); //if successfully executed if (rowEffeted > 0) { Int32 batchMasterId = Convert.ToInt32(parameterList[parameterList.Count() - 1].Value); return(batchMasterId); } else { //LoggingService.Instance.Fatal(string.Format("Unable to add user :{0}{1}", Environment.NewLine, object)); } return(0); }
// call report with reportname only void callreport(string Reportname) { Telerik.Reporting.TypeReportSource typeReportSource = new Telerik.Reporting.TypeReportSource(); string reportname; reportname = Reportname; switch (reportname) { #region Master case "Action Maintenance": ActionIDMaintenance ActionMaintenance = new ActionIDMaintenance(); typeReportSource.TypeName = typeof(ActionIDMaintenance).AssemblyQualifiedName; break; case "Batch Setup": BatchMaster BatchList = new BatchMaster(); typeReportSource.TypeName = typeof(BatchMaster).AssemblyQualifiedName; break; case "Company Asset Setup": //CompanyAssetMaster companyAsset = new CompanyAssetMaster(); //typeReportSource.TypeName = typeof(CompanyAssetMaster).AssemblyQualifiedName; break; case "Complain Code Setup": ComplainMaster complainCode = new ComplainMaster(); typeReportSource.TypeName = typeof(ComplainMaster).AssemblyQualifiedName; break; case "Country Setup": CountrySetup countrySetup = new CountrySetup(); typeReportSource.TypeName = typeof(CountrySetup).AssemblyQualifiedName; break; case "Daytype Setup": DayMaster dayTYpeSetup = new DayMaster(); typeReportSource.TypeName = typeof(DayMaster).AssemblyQualifiedName; break; case "Division Setup": DivisionMaster divisionMaster = new DivisionMaster(); typeReportSource.TypeName = typeof(DivisionMaster).AssemblyQualifiedName; break; case "Facility Setup": FacilitiesMaster facilitiesMaster = new FacilitiesMaster(); typeReportSource.TypeName = typeof(FacilitiesMaster).AssemblyQualifiedName; break; case "Nationality Setup": NationalityMaster nationalityMaster = new NationalityMaster(); typeReportSource.TypeName = typeof(NationalityMaster).AssemblyQualifiedName; break; case "Religion Setup": ReligionMaster religionMaster = new ReligionMaster(); typeReportSource.TypeName = typeof(ReligionMaster).AssemblyQualifiedName; break; case "Room Setup": RoomMaster roomMaster = new RoomMaster(); typeReportSource.TypeName = typeof(RoomMaster).AssemblyQualifiedName; break; case "Suggestion Master": SuggestionMaster suggestionMaster = new SuggestionMaster(); typeReportSource.TypeName = typeof(SuggestionMaster).AssemblyQualifiedName; break; case "Employer Setup": EmployerMaster employerMaster = new EmployerMaster(); typeReportSource.TypeName = typeof(EmployerMaster).AssemblyQualifiedName; break; case "Loan Type": SuggestionMaster suggestionMaster1 = new SuggestionMaster(); typeReportSource.TypeName = typeof(SuggestionMaster).AssemblyQualifiedName; break; #endregion #region Setup case "Attendence Machine": AttendenceSetup AttendenceSetup = new AttendenceSetup(); typeReportSource.TypeName = typeof(AttendenceSetup).AssemblyQualifiedName; break; case "Benefit Setup": BenefitMaster BenefitMaster = new BenefitMaster(); typeReportSource.TypeName = typeof(BenefitMaster).AssemblyQualifiedName; break; case "Branch Setup": BranchMaster branchmaster = new BranchMaster(); typeReportSource.TypeName = typeof(BranchMaster).AssemblyQualifiedName; break; case "Calender Setup": CalenderSetup CalenderList = new CalenderSetup(); typeReportSource.TypeName = typeof(CalenderSetup).AssemblyQualifiedName; break; case "Deduction Setup": DeductionMaster DeductionList = new DeductionMaster(); typeReportSource.TypeName = typeof(DeductionMaster).AssemblyQualifiedName; break; case "Employee Class Setup": ClassMaster classMaster = new ClassMaster(); typeReportSource.TypeName = typeof(ClassMaster).AssemblyQualifiedName; break; case "End of Service Master": EOSMaster eOSList = new EOSMaster(); typeReportSource.TypeName = typeof(EOSMaster).AssemblyQualifiedName; break; case "Grade Setup": EOSMaster eOSList1 = new EOSMaster(); typeReportSource.TypeName = typeof(EOSMaster).AssemblyQualifiedName; break; case "Gratuity Setup": GratuitySetup GratuityList = new GratuitySetup(); typeReportSource.TypeName = typeof(GratuitySetup).AssemblyQualifiedName; break; case "Leave Assignment": LeaveMasterMaster LeaveCodeList = new LeaveMasterMaster(); typeReportSource.TypeName = typeof(LeaveMasterMaster).AssemblyQualifiedName; break; case "Leave Type": LeaveMasterMaster LeaveCodeList1 = new LeaveMasterMaster(); typeReportSource.TypeName = typeof(LeaveMasterMaster).AssemblyQualifiedName; break; case "Overtime Setup": OvertimeSetup OvertimeList = new OvertimeSetup(); typeReportSource.TypeName = typeof(OvertimeSetup).AssemblyQualifiedName; break; case "Pay Code Setup": PaycodeMaster PaycodeList = new PaycodeMaster(); typeReportSource.TypeName = typeof(PaycodeMaster).AssemblyQualifiedName; break; case "Position Setup": PositionSetup PositionList = new PositionSetup(); typeReportSource.TypeName = typeof(PositionSetup).AssemblyQualifiedName; break; case "Project Setup": ProjectMaster ProjectList = new ProjectMaster(); typeReportSource.TypeName = typeof(ProjectMaster).AssemblyQualifiedName; break; case "Supervisor Setup": SuperviserSetup SuperviserList = new SuperviserSetup(); typeReportSource.TypeName = typeof(SuperviserSetup).AssemblyQualifiedName; break; case "Transaction Sequence": TransactionSequence TransactionSequenceList = new TransactionSequence(); typeReportSource.TypeName = typeof(TransactionSequence).AssemblyQualifiedName; break; #endregion #region Employee case "Employee Pay Code": EmployeeMonthlySalary employeeMonthlySalary = new EmployeeMonthlySalary(); typeReportSource.TypeName = typeof(EmployeeMonthlySalary).AssemblyQualifiedName; break; case "Employee Address": EmployeeAddresslist employeeAddresslist = new EmployeeAddresslist(); typeReportSource.TypeName = typeof(EmployeeAddresslist).AssemblyQualifiedName; break; case "Employee Card": EmployeeCard employeeCard = new EmployeeCard(); typeReportSource.TypeName = typeof(EmployeeCard).AssemblyQualifiedName; break; case "Employee Contract": EmployeeContractlist employeeContractlist = new EmployeeContractlist(); typeReportSource.TypeName = typeof(EmployeeContractlist).AssemblyQualifiedName; break; case "Employee IBAN": EmployeeIBANChecking employeeIBANChecking = new EmployeeIBANChecking(); typeReportSource.TypeName = typeof(EmployeeIBANChecking).AssemblyQualifiedName; break; case "Employee Master": EmployeeMasterList employeeMasterList = new EmployeeMasterList(); typeReportSource.TypeName = typeof(EmployeeMasterList).AssemblyQualifiedName; break; case "Employee Personal Info": EmployeePersonalinfo employeePersonalinfo = new EmployeePersonalinfo(); typeReportSource.TypeName = typeof(EmployeePersonalinfo).AssemblyQualifiedName; break; //case "Employee Master": // Employeemaster employeePersonalinfo = new EmployeePersonalinfo(); // typeReportSource.TypeName = typeof(EmployeePersonalinfo).AssemblyQualifiedName; // break; #endregion case "BenefitDetailList": BenefitDetailDRL BenefitDetailList = new BenefitDetailDRL(); typeReportSource.TypeName = typeof(BenefitDetailDRL).AssemblyQualifiedName; break; case "BranchList": BranchMaster BranchList = new BranchMaster(); typeReportSource.TypeName = typeof(BranchMaster).AssemblyQualifiedName; break; case "ClassList": ClassMaster ClassList = new ClassMaster(); typeReportSource.TypeName = typeof(ClassMaster).AssemblyQualifiedName; break; case "DeductionWithDetailList": DeductionDetailDRL DeductionWithDetailList = new DeductionDetailDRL(); typeReportSource.TypeName = typeof(DeductionDetailDRL).AssemblyQualifiedName; break; /* case "DeductionDetailList": * * DeductionWithDetailList DeductionDetailList = new DeductionWithDetailList(); * typeReportSource.TypeName = typeof(DeductionWithDetailList).AssemblyQualifiedName; * break; */ case "GratuitywithDetailList": GratuitySetupDRL GratuitywithDetailList = new GratuitySetupDRL(); typeReportSource.TypeName = typeof(GratuitySetupDRL).AssemblyQualifiedName; break; case "GratuityDTLList": GratuitySetupDTL GratuityDTLList = new GratuitySetupDTL(); typeReportSource.TypeName = typeof(GratuitySetupDTL).AssemblyQualifiedName; break; case "GratuityPaycodeList": GratuityPaycode GratuityPaycodeList = new GratuityPaycode(); typeReportSource.TypeName = typeof(GratuityPaycode).AssemblyQualifiedName; break; case "LeavePatternList": LeavePattern LeavePatternList = new LeavePattern(); typeReportSource.TypeName = typeof(LeavePattern).AssemblyQualifiedName; break; case "OvertimeWithDetailList": OvertimeSetupDRL OvertimeWithDetailList = new OvertimeSetupDRL(); typeReportSource.TypeName = typeof(OvertimeSetupDRL).AssemblyQualifiedName; break; case "OvertimeDTLList": OvertimeSetupDTL OvertimeDTLList = new OvertimeSetupDTL(); typeReportSource.TypeName = typeof(OvertimeSetupDTL).AssemblyQualifiedName; break; case "OvertimePaycodeList": OvertimePaycode OvertimePaycodeList = new OvertimePaycode(); typeReportSource.TypeName = typeof(OvertimePaycode).AssemblyQualifiedName; break; #region Leave Transaction Reports case "LeavetransactionbyID": LeaveTrxEntryByID LeaveTransaction = new LeaveTrxEntryByID(); typeReportSource.TypeName = typeof(LeaveTrxEntryByID).AssemblyQualifiedName; break; #endregion } ReportViewer1.ReportSource = typeReportSource; ReportViewer1.RefreshReport(); }
protected void Page_UnLoad(object sender, EventArgs e) { objCommonClass = null; objBatchMaster = null; }
public DataBaseResultSet SaveBatchMaster <T>(T objData) where T : class, IModel, new() { BatchMaster obj = objData as BatchMaster; string sQuery = "sprocBatchMasterInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("BatchCode", "BatchCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.BatchCode)); list.Add(SqlConnManager.GetConnParameters("ICode", "ICode", 13, GenericDataType.String, ParameterDirection.Input, obj.ICode)); list.Add(SqlConnManager.GetConnParameters("ProductCode", "ProductCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.ProductCode)); list.Add(SqlConnManager.GetConnParameters("AccountCode", "AccountCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode)); list.Add(SqlConnManager.GetConnParameters("MRP", "MRP", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.MRP)); list.Add(SqlConnManager.GetConnParameters("BatchNo", "BatchNo", 15, GenericDataType.String, ParameterDirection.Input, obj.BatchNo)); list.Add(SqlConnManager.GetConnParameters("Expiry", "Expiry", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.Expiry)); list.Add(SqlConnManager.GetConnParameters("Inclusive", "Inclusive", 3, GenericDataType.String, ParameterDirection.Input, obj.Inclusive)); list.Add(SqlConnManager.GetConnParameters("VatOn", "VatOn", 5, GenericDataType.String, ParameterDirection.Input, obj.VatOn)); list.Add(SqlConnManager.GetConnParameters("Vat", "Vat", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Vat)); list.Add(SqlConnManager.GetConnParameters("AdVat", "AdVat", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.AdVat)); list.Add(SqlConnManager.GetConnParameters("Octroi", "Octroi", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Octroi)); list.Add(SqlConnManager.GetConnParameters("PurRs", "PurRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.PurRs)); list.Add(SqlConnManager.GetConnParameters("SaleRs", "SaleRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SaleRs)); list.Add(SqlConnManager.GetConnParameters("NetRate", "NetRate", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.NetRate)); list.Add(SqlConnManager.GetConnParameters("StockPt", "StockPt", 8, GenericDataType.Long, ParameterDirection.Input, obj.StockPt)); list.Add(SqlConnManager.GetConnParameters("OpQty", "OpQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OpQty)); list.Add(SqlConnManager.GetConnParameters("OpQtyRs", "OpQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OpQtyRs)); list.Add(SqlConnManager.GetConnParameters("OpFQty", "OpFQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OpFQty)); list.Add(SqlConnManager.GetConnParameters("OpFQtyRs", "OpFQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.OpFQtyRs)); list.Add(SqlConnManager.GetConnParameters("PurQty", "PurQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.PurQty)); list.Add(SqlConnManager.GetConnParameters("PurQtyRs", "PurQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.PurQtyRs)); list.Add(SqlConnManager.GetConnParameters("PurFQty", "PurFQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.PurFQty)); list.Add(SqlConnManager.GetConnParameters("PurFQtyRs", "PurFQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.PurFQtyRs)); list.Add(SqlConnManager.GetConnParameters("CrQty", "CrQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CrQty)); list.Add(SqlConnManager.GetConnParameters("CrQtyRs", "CrQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CrQtyRs)); list.Add(SqlConnManager.GetConnParameters("CrFQty", "CrFQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CrFQty)); list.Add(SqlConnManager.GetConnParameters("CrFQtyRs", "CrFQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.CrFQtyRs)); list.Add(SqlConnManager.GetConnParameters("RcptQty", "RcptQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.RcptQty)); list.Add(SqlConnManager.GetConnParameters("RcptQtyRs", "RcptQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.RcptQtyRs)); list.Add(SqlConnManager.GetConnParameters("SaleQty", "SaleQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SaleQty)); list.Add(SqlConnManager.GetConnParameters("SaleQtyRs", "SaleQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SaleQtyRs)); list.Add(SqlConnManager.GetConnParameters("SaleFQty", "SaleFQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SaleFQty)); list.Add(SqlConnManager.GetConnParameters("SaleFQtyRs", "SaleFQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SaleFQtyRs)); list.Add(SqlConnManager.GetConnParameters("IssueQty", "IssueQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.IssueQty)); list.Add(SqlConnManager.GetConnParameters("IssueQtyRs", "IssueQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.IssueQtyRs)); list.Add(SqlConnManager.GetConnParameters("ClQty", "ClQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ClQty)); list.Add(SqlConnManager.GetConnParameters("ClQtyRs", "ClQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ClQtyRs)); list.Add(SqlConnManager.GetConnParameters("ClFQty", "ClFQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ClFQty)); list.Add(SqlConnManager.GetConnParameters("ClFQtyRs", "ClFQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.ClFQtyRs)); list.Add(SqlConnManager.GetConnParameters("TQty", "TQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.TQty)); list.Add(SqlConnManager.GetConnParameters("TQtyRs", "TQtyRs", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.TQtyRs)); list.Add(SqlConnManager.GetConnParameters("BarSeries", "BarSeries", 2, GenericDataType.String, ParameterDirection.Input, obj.BarSeries)); list.Add(SqlConnManager.GetConnParameters("BarCode", "BarCode", 13, GenericDataType.String, ParameterDirection.Input, obj.BarCode)); list.Add(SqlConnManager.GetConnParameters("BatchHead", "BatchHead", 10, GenericDataType.String, ParameterDirection.Input, obj.BatchHead)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("DLock", "DLock", 3, GenericDataType.String, ParameterDirection.Input, obj.DLock)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }