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