public ActionResult DeleteConfirmed(int id)
{
REPORT rEPORT = db.REPORT.Find(id);
db.REPORT.Remove(rEPORT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static REPORT GetREPORTByID(int id)
{
REPORT rEPORT = new REPORT();
SqlREPORTProvider sqlREPORTProvider = new SqlREPORTProvider();
rEPORT = sqlREPORTProvider.GetREPORTByID(id);
return(rEPORT);
}
private void PopulateEntity(ref REPORT entity)
{
entity.NAME = txtName.Text;
entity.REPORTDATEFROM = DateTime.ParseExact(txtDateFrom.Text, "dd-MM-yyyy", CultureInfo.InvariantCulture);
entity.REPORTDATETO = DateTime.ParseExact(txtDateTo.Text, "dd-MM-yyyy", CultureInfo.InvariantCulture);
entity.REQUESTSTATUS = RequestStatus.New.ToString();
entity.MODIFIEDON = DateTime.Now;
entity.SYSTEMUSERID = LoggedInUser.ID;
}
public ActionResult Edit([Bind(Include = "ID_REPORT,ID_KOMEN,ID_ANSWER,ID_KATEGORY")] REPORT rEPORT)
{
if (ModelState.IsValid)
{
db.Entry(rEPORT).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID_ANSWER = new SelectList(db.ANSWER, "ID_ANSWER", "POST_KOMENT", rEPORT.ID_ANSWER);
ViewBag.ID_KATEGORY = new SelectList(db.KATEGORY_REPORT, "ID_KATEGORY", "NAMA_KATEGORY", rEPORT.ID_KATEGORY);
ViewBag.ID_KOMEN = new SelectList(db.KOMENTAR, "ID_KOMEN", "POST_KOMEN", rEPORT.ID_KOMEN);
return(View(rEPORT));
}
//post method
public ActionResult CreateTestDB(TEST test)
{
TestService testService = new TestService();
PostService postService = new PostService();
DateTime postTime = postService.findById(test.POST_ID.ToString()).END_DATE;
//startime early than post created time
if (DateTime.Compare(postTime, test.START_TIME) < 0)
{
//endtime late than start time
if (DateTime.Compare(test.START_TIME, test.END_TIME) < 0)
{
//starttime early than now
if (DateTime.Compare(test.START_TIME, DateTime.Now) < 0)
{
return(RedirectToAction("CreateTest", new { error = "Can't create a test with the start time has passed" }));
}
//check create test
else if (testService.create(test))
{
//create report
REPORT report = new REPORT()
{
CREATED = test.END_TIME, PERCENT_HIGH_SCORE = 0, PERCENT_MIDDLE_SCORE = 0, PERCENT_ATTEMPT = 0, PERCENT_FAST_FINISH = 0, PERCENT_HIGH_PART_1 = 0, PERCENT_HIGH_PART_2 = 0, PERCENT_HIGH_PART_3 = 0, PERCENT_MID_PART_1 = 0, PERCENT_MID_PART_2 = 0, PERCENT_MID_PART_3 = 0
};
ReportService reportService = new ReportService();
if (reportService.create(report))
{
return(RedirectToAction("ShowTests"));
}
else
{
return(RedirectToAction("CreateTest", new { error = "Can't Create Report. Please create again" }));
}
}
else
{
return(RedirectToAction("CreateTest", new { error = "Missing Questions. Please create again" }));
}
}
else
{
return(RedirectToAction("CreateTest", new { error = "The End Time must after the Start Time" }));
}
}
else
{
return(RedirectToAction("CreateTest", new { error = "The Start time must after the Post end time" }));
}
}
public long Insert(USER UserCreator, string RecordID, string ReportFilePath, string ReportFileName, DateTime CreatedOn)
{
DataClasses1DataContext classes1DataContext = new DataClasses1DataContext();
REPORT entity = new REPORT();
entity.IDUserCreator = UserCreator.ID;
entity.RecordID = RecordID;
entity.ReportFilePath = ReportFilePath;
entity.ReportFileName = ReportFileName;
entity.CreatedOn = CreatedOn;
classes1DataContext.REPORTs.InsertOnSubmit(entity);
classes1DataContext.SubmitChanges();
return(entity.ID);
}
public ActionResult Create([Bind(Include = "ID_REPORT,ID_KOMEN,ID_ANSWER,ID_KATEGORY")] REPORT rEPORT)
{
if (ModelState.IsValid)
{
db.REPORT.Add(rEPORT);
db.SaveChanges();
return(RedirectToAction("../SHARINGs"));
}
ViewBag.ID_ANSWER = new SelectList(db.ANSWER, "ID_ANSWER", "POST_KOMENT", rEPORT.ID_ANSWER);
ViewBag.ID_KATEGORY = new SelectList(db.KATEGORY_REPORT, "ID_KATEGORY", "NAMA_KATEGORY", rEPORT.ID_KATEGORY);
ViewBag.ID_KOMEN = new SelectList(db.KOMENTAR, "ID_KOMEN", "POST_KOMEN", rEPORT.ID_KOMEN);
return(View(rEPORT));
}
// GET: REPORTs/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
REPORT rEPORT = db.REPORT.Find(id);
if (rEPORT == null)
{
return(HttpNotFound());
}
return(View(rEPORT));
}
// GET: REPORTs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
REPORT rEPORT = db.REPORT.Find(id);
if (rEPORT == null)
{
return(HttpNotFound());
}
ViewBag.ID_ANSWER = new SelectList(db.ANSWER, "ID_ANSWER", "POST_KOMENT", rEPORT.ID_ANSWER);
ViewBag.ID_KATEGORY = new SelectList(db.KATEGORY_REPORT, "ID_KATEGORY", "NAMA_KATEGORY", rEPORT.ID_KATEGORY);
ViewBag.ID_KOMEN = new SelectList(db.KOMENTAR, "ID_KOMEN", "POST_KOMEN", rEPORT.ID_KOMEN);
return(View(rEPORT));
}
private bool CopyFromForm()
{
var isValid = true;
if (DateTime.ParseExact(txtDateFrom.Text, "dd-MM-yyyy", CultureInfo.InvariantCulture) >
DateTime.ParseExact(txtDateTo.Text, "dd-MM-yyyy", CultureInfo.InvariantCulture))
{
ShowMessage(MessageType.Warning, "Your Date From date should be before your Date To date");
isValid = false;
}
var selectedFields = jsReportFields_value.Value.Split(',');
if (selectedFields.Length == 0)
{
ShowMessage(MessageType.Warning, "You have not chosen any fields - please select at least 1 field.");
isValid = false;
}
if (jsReportSites.SelectedItems.Count == 0)
{
ShowMessage(MessageType.Warning, "You have not chosen any sites - please select at least 1 site.");
isValid = false;
}
if (selectedFields.Length > 256)
{
ShowMessage(MessageType.Warning, "You have chosen too many fields, please select less than 256.");
isValid = false;
}
if (!isValid)
{
return(false);
}
using (var ctx = new Entities())
{
try
{
var dataSource = new REPORT();
if (btnFormButtons.EntityID.HasValue)
{
var id = btnFormButtons.EntityID;
dataSource = ctx.REPORTs.FirstOrDefault(u => u.ID == id);
PopulateEntity(ref dataSource);
Audit.Log(ctx, AuditType.Edit, this.Page.GetType().FullName,
string.Format("Report Edited. ID: {0}", dataSource.ID), LoggedInUser.ID);
// remove any cached data
var datastore = new DataStore(ConfigurationSettings.AppSettings["datastore_path"]);
datastore.Remove(id.Value);
}
else
{
dataSource = new REPORT
{
CREATEDON = DateTime.Now,
DELETED = 0
};
PopulateEntity(ref dataSource);
ctx.AddToREPORTs(dataSource);
Audit.Log(ctx, AuditType.Add, this.Page.GetType().FullName,
string.Format("Report Added. Name: {0}", dataSource.NAME), LoggedInUser.ID);
}
ctx.SaveChanges();
var fieldsChanged = (jsReportFields_changed.Value != string.Empty);
if (fieldsChanged)
{
EntityExtensions.ExecuteProcedure(new EntityConnection(ctx.Connection.ConnectionString),
"Entities.ClearReportFields",
new KeyValuePair <string, object>("REPORT_ID", dataSource.ID));
var order = 0;
foreach (var item in selectedFields)
{
var reportField = new REPORTFIELD
{
REPORTID = dataSource.ID,
FIELDID = (short)int.Parse(item),
FIELDORDER = (short)order
};
ctx.AddToREPORTFIELDs(reportField);
order++;
}
}
if (jsReportSites.ValueChanged)
{
EntityExtensions.ExecuteProcedure(new EntityConnection(ctx.Connection.ConnectionString),
"Entities.ClearReportSites",
new KeyValuePair <string, object>("REPORT_ID", dataSource.ID));
foreach (var item in jsReportSites.SelectedItems)
{
var reportSite = new REPORTSITE {
REPORTID = dataSource.ID, SITEID = (short)int.Parse(item.Value)
};
ctx.AddToREPORTSITEs(reportSite);
}
}
if (fieldsChanged || jsReportSites.ValueChanged)
{
ctx.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
ExceptionLog.WriteException("Save Report", ex);
ShowMessage(MessageType.Error, "There was an error saving this record");
}
}
return(false);
}
//update with the result of the test. Check all again then assign to the report
public ActionResult UpdateReport(DateTime created)
{
ReportService reportService = new ReportService();
ResultService resultService = new ResultService();
TestService testService = new TestService();
//find test
int testId = reportService.findTestIdWithCreated(created);
//get each sum scores
int GK_score = testService.GetScoreFromTestAndCategory(testId, "GENERAL KNOWLEDGE");
int M_score = testService.GetScoreFromTestAndCategory(testId, "MATHEMATICS");
int CT_score = testService.GetScoreFromTestAndCategory(testId, "COMPUTER TECHNOLOGY");
int sum_score = testService.GetScoreFromTestAndCategory(testId, "none");
//list result of candidates took the test
List <RESULT> results = resultService.FindResultByTestId(testId);
//assign 0
int attemp = 0, sum_high = 0, sum_middle = 0, GK_high = 0, GK_middle = 0, M_high = 0, M_middle = 0, CT_high = 0, CT_middle = 0;
foreach (var r in results)
{
//didnt come to the test
if (r.TEST_INDEX != 0)
{
//Count then sum/count = average
attemp = attemp + 1;
if ((r.TEST_RESULT_1 + r.TEST_RESULT_2 + r.TEST_RESULT_3) >= ((double)sum_score * 80 / 100))
{
sum_high = sum_high + 1;
}
else if ((r.TEST_RESULT_1 + r.TEST_RESULT_2 + r.TEST_RESULT_3) >= ((double)sum_score * 50 / 100))
{
sum_middle = sum_middle + 1;
}
//GK
if (r.TEST_RESULT_1 >= ((double)GK_score * 80 / 100))
{
GK_high = GK_high + 1;
}
else if (r.TEST_RESULT_1 >= ((double)GK_score * 50 / 100))
{
GK_middle = GK_middle + 1;
}
//M
if (r.TEST_RESULT_2 >= ((double)M_score * 80 / 100))
{
M_high = M_high + 1;
}
else if (r.TEST_RESULT_2 >= ((double)M_score * 50 / 100))
{
M_middle = M_middle + 1;
}
//CT
if (r.TEST_RESULT_3 >= ((double)CT_score * 80 / 100))
{
CT_high = CT_high + 1;
}
else if (r.TEST_RESULT_3 >= ((double)CT_score * 50 / 100))
{
CT_middle = CT_middle + 1;
}
}
}
int quantity = results.Count();
double resu = (double)sum_middle / quantity;
REPORT report = new REPORT()
{
//Average
CREATED = created,
PERCENT_HIGH_SCORE = ((double)sum_high / quantity) * 100,
PERCENT_MIDDLE_SCORE = ((double)sum_middle / quantity) * 100,
PERCENT_ATTEMPT = attemp,
PERCENT_FAST_FINISH = 0,
PERCENT_HIGH_PART_1 = ((double)GK_high / quantity) * 100,
PERCENT_HIGH_PART_2 = ((double)M_high / quantity) * 100,
PERCENT_HIGH_PART_3 = ((double)CT_high / quantity) * 100,
PERCENT_MID_PART_1 = ((double)GK_middle / quantity) * 100,
PERCENT_MID_PART_2 = ((double)M_middle / quantity) * 100,
PERCENT_MID_PART_3 = ((double)CT_middle / quantity) * 100
};
if (reportService.update(report))
{
return(RedirectToAction("Index", "Manager"));
}
else
{
return(RedirectToAction("Index", "Manager"));
}
}
public static bool UpdateREPORT(REPORT rEPORT)
{
SqlREPORTProvider sqlREPORTProvider = new SqlREPORTProvider();
return(sqlREPORTProvider.UpdateREPORT(rEPORT));
}
public static int InsertREPORT(REPORT rEPORT)
{
SqlREPORTProvider sqlREPORTProvider = new SqlREPORTProvider();
return(sqlREPORTProvider.InsertREPORT(rEPORT));
}
public REPORT GetREPORTFromReader(IDataReader reader)
{
try
{
REPORT rEPORT = new REPORT
(
(int)reader["REPORTID"],
(DateTime)reader["DT"],
(int)reader["BEGININGBALANCE"],
(int)reader["CASHFROM1"],
reader["CASHFROM1REMARKS"].ToString(),
(int)reader["CASHFROM2"],
reader["CASHFROM2REMARKS"].ToString(),
(int)reader["CASHFROM3"],
reader["CASHFROM3REMARKS"].ToString(),
(int)reader["CASHFROM4"],
reader["CASHFROM4REMARKS"].ToString(),
(int)reader["CASHFROM5"],
reader["CASHFROM5REMARKS"].ToString(),
(int)reader["CASHFROM6"],
reader["CASHFROM6REMARKS"].ToString(),
(int)reader["CASHFROM7"],
reader["CASHFROM7REMARKS"].ToString(),
(int)reader["CASHFROM8"],
reader["CASHFROM8REMARKS"].ToString(),
(int)reader["CASHFROM9"],
reader["CASHFROM9REMARKS"].ToString(),
(int)reader["CASHFROM10"],
reader["CASHFROM10REMARKS"].ToString(),
(int)reader["CASHFROM11"],
reader["CASHFROM11REMARKS"].ToString(),
(int)reader["CASHFROM12"],
reader["CASHFROM12REMARKS"].ToString(),
(int)reader["WU"],
(int)reader["WUCOUNT"],
(int)reader["CONVPAY"],
(int)reader["CONVPAYCOUNT"],
(int)reader["MO"],
(int)reader["MOCOMM"],
(int)reader["MOCOUNT"],
(int)reader["FEDILITY"],
(int)reader["FEDILITYCOMM"],
(int)reader["FEDILITYCOUNT"],
(int)reader["GLOBALEXPRESS"],
(int)reader["GLOBALEXPRESSCOMM"],
(int)reader["GLOBALEXPRESSCOUNT"],
(int)reader["CHECKFREEPAY"],
(int)reader["CHECKFREEPAYCOMM"],
(int)reader["CHECKFREEPAYCOUNT"],
(int)reader["PRECASH"],
(int)reader["PRECASHCOMM"],
(int)reader["PRECASHCOUNT"],
(int)reader["PHONECARD"],
(int)reader["IDCARD"],
(int)reader["IDCARDCOUNT"],
(int)reader["CHECKCOMM"],
(int)reader["CHECKCOUNT"],
(int)reader["TOTALCASHIN"],
(int)reader["CASHDEPOSIT1"],
(int)reader["CASHDEPOSIT2"],
(int)reader["CASHDEPOSIT3"],
(int)reader["CASHDEPOSIT4"],
(int)reader["CASHDEPOSIT5"],
(int)reader["CHECKDEPOSIT1"],
(int)reader["CHECKDEPOSIT2"],
(int)reader["CHECKDEPOSIT3"],
(int)reader["CHECKDEPOSIT4"],
(int)reader["CHECKDEPOSIT5"],
(int)reader["CHECKDEPOSIT6"],
(int)reader["CHECKDEPOSIT7"],
(int)reader["CHECKDEPOSIT8"],
(int)reader["CHECKDEPOSIT9"],
(int)reader["CHECKDEPOSIT10"],
(int)reader["CHECKDEPOSIT11"],
(int)reader["CHECKDEPOSIT12"],
(int)reader["CASHTRANSFER1"],
reader["CASHTRANSFER1REMARKS"].ToString(),
(int)reader["CASHTRANSFER2"],
reader["CASHTRANSFER2REMARKS"].ToString(),
(int)reader["CASHTRANSFER3"],
reader["CASHTRANSFER3REMARKS"].ToString(),
(int)reader["CASHTRANSFER4"],
reader["CASHTRANSFER4REMARKS"].ToString(),
(int)reader["CASHTRANSFER5"],
reader["CASHTRANSFER5REMARKS"].ToString(),
(int)reader["CASHTRANSFER6"],
reader["CASHTRANSFER6REMARKS"].ToString(),
(int)reader["CASHTRANSFER7"],
reader["CASHTRANSFER7REMARKS"].ToString(),
(int)reader["CASHTRANSFER8"],
reader["CASHTRANSFER8REMARKS"].ToString(),
(int)reader["FEDILITYDEPOSIT"],
(int)reader["CHECKFREEPAYDEPOSIT"],
(int)reader["CONVPAYDEPOSIT"],
(int)reader["WUPAYOUT"],
(int)reader["CREDITCARD"],
(int)reader["EXPENSES"],
(int)reader["TOTALCASHOUT"],
(int)reader["TOTALBALANCE"],
(int)reader["ACTUALBALACE"],
(int)reader["SHORTOVER"],
(int)reader["EMP_ID"],
(int)reader["STATION_ID"],
(int)reader["SHIFT_ID"],
(DateTime)reader["SHIFTOPEN"],
(DateTime)reader["SHIFTCLOSE"]
);
return(rEPORT);
}
catch (Exception ex)
{
return(null);
}
}
public bool UpdateREPORT(REPORT rEPORT)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateREPORT", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@REPORTID", SqlDbType.Int).Value = rEPORT.REPORTID;
cmd.Parameters.Add("@DT", SqlDbType.DateTime).Value = rEPORT.DT;
cmd.Parameters.Add("@BEGININGBALANCE", SqlDbType.Int).Value = rEPORT.BEGININGBALANCE;
cmd.Parameters.Add("@CASHFROM1", SqlDbType.Int).Value = rEPORT.CASHFROM1;
cmd.Parameters.Add("@CASHFROM1REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHFROM1REMARKS;
cmd.Parameters.Add("@CASHFROM2", SqlDbType.Int).Value = rEPORT.CASHFROM2;
cmd.Parameters.Add("@CASHFROM2REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHFROM2REMARKS;
cmd.Parameters.Add("@CASHFROM3", SqlDbType.Int).Value = rEPORT.CASHFROM3;
cmd.Parameters.Add("@CASHFROM3REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHFROM3REMARKS;
cmd.Parameters.Add("@CASHFROM4", SqlDbType.Int).Value = rEPORT.CASHFROM4;
cmd.Parameters.Add("@CASHFROM4REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHFROM4REMARKS;
cmd.Parameters.Add("@CASHFROM5", SqlDbType.Int).Value = rEPORT.CASHFROM5;
cmd.Parameters.Add("@CASHFROM5REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHFROM5REMARKS;
cmd.Parameters.Add("@CASHFROM6", SqlDbType.Int).Value = rEPORT.CASHFROM6;
cmd.Parameters.Add("@CASHFROM6REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHFROM6REMARKS;
cmd.Parameters.Add("@CASHFROM7", SqlDbType.Int).Value = rEPORT.CASHFROM7;
cmd.Parameters.Add("@CASHFROM7REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHFROM7REMARKS;
cmd.Parameters.Add("@CASHFROM8", SqlDbType.Int).Value = rEPORT.CASHFROM8;
cmd.Parameters.Add("@CASHFROM8REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHFROM8REMARKS;
cmd.Parameters.Add("@CASHFROM9", SqlDbType.Int).Value = rEPORT.CASHFROM9;
cmd.Parameters.Add("@CASHFROM9REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHFROM9REMARKS;
cmd.Parameters.Add("@CASHFROM10", SqlDbType.Int).Value = rEPORT.CASHFROM10;
cmd.Parameters.Add("@CASHFROM10REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHFROM10REMARKS;
cmd.Parameters.Add("@CASHFROM11", SqlDbType.Int).Value = rEPORT.CASHFROM11;
cmd.Parameters.Add("@CASHFROM11REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHFROM11REMARKS;
cmd.Parameters.Add("@CASHFROM12", SqlDbType.Int).Value = rEPORT.CASHFROM12;
cmd.Parameters.Add("@CASHFROM12REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHFROM12REMARKS;
cmd.Parameters.Add("@WU", SqlDbType.Int).Value = rEPORT.WU;
cmd.Parameters.Add("@WUCOUNT", SqlDbType.Int).Value = rEPORT.WUCOUNT;
cmd.Parameters.Add("@CONVPAY", SqlDbType.Int).Value = rEPORT.CONVPAY;
cmd.Parameters.Add("@CONVPAYCOUNT", SqlDbType.Int).Value = rEPORT.CONVPAYCOUNT;
cmd.Parameters.Add("@MO", SqlDbType.Int).Value = rEPORT.MO;
cmd.Parameters.Add("@MOCOMM", SqlDbType.Int).Value = rEPORT.MOCOMM;
cmd.Parameters.Add("@MOCOUNT", SqlDbType.Int).Value = rEPORT.MOCOUNT;
cmd.Parameters.Add("@FEDILITY", SqlDbType.Int).Value = rEPORT.FEDILITY;
cmd.Parameters.Add("@FEDILITYCOMM", SqlDbType.Int).Value = rEPORT.FEDILITYCOMM;
cmd.Parameters.Add("@FEDILITYCOUNT", SqlDbType.Int).Value = rEPORT.FEDILITYCOUNT;
cmd.Parameters.Add("@GLOBALEXPRESS", SqlDbType.Int).Value = rEPORT.GLOBALEXPRESS;
cmd.Parameters.Add("@GLOBALEXPRESSCOMM", SqlDbType.Int).Value = rEPORT.GLOBALEXPRESSCOMM;
cmd.Parameters.Add("@GLOBALEXPRESSCOUNT", SqlDbType.Int).Value = rEPORT.GLOBALEXPRESSCOUNT;
cmd.Parameters.Add("@CHECKFREEPAY", SqlDbType.Int).Value = rEPORT.CHECKFREEPAY;
cmd.Parameters.Add("@CHECKFREEPAYCOMM", SqlDbType.Int).Value = rEPORT.CHECKFREEPAYCOMM;
cmd.Parameters.Add("@CHECKFREEPAYCOUNT", SqlDbType.Int).Value = rEPORT.CHECKFREEPAYCOUNT;
cmd.Parameters.Add("@PRECASH", SqlDbType.Int).Value = rEPORT.PRECASH;
cmd.Parameters.Add("@PRECASHCOMM", SqlDbType.Int).Value = rEPORT.PRECASHCOMM;
cmd.Parameters.Add("@PRECASHCOUNT", SqlDbType.Int).Value = rEPORT.PRECASHCOUNT;
cmd.Parameters.Add("@PHONECARD", SqlDbType.Int).Value = rEPORT.PHONECARD;
cmd.Parameters.Add("@IDCARD", SqlDbType.Int).Value = rEPORT.IDCARD;
cmd.Parameters.Add("@IDCARDCOUNT", SqlDbType.Int).Value = rEPORT.IDCARDCOUNT;
cmd.Parameters.Add("@CHECKCOMM", SqlDbType.Int).Value = rEPORT.CHECKCOMM;
cmd.Parameters.Add("@CHECKCOUNT", SqlDbType.Int).Value = rEPORT.CHECKCOUNT;
cmd.Parameters.Add("@TOTALCASHIN", SqlDbType.Int).Value = rEPORT.TOTALCASHIN;
cmd.Parameters.Add("@CASHDEPOSIT1", SqlDbType.Int).Value = rEPORT.CASHDEPOSIT1;
cmd.Parameters.Add("@CASHDEPOSIT2", SqlDbType.Int).Value = rEPORT.CASHDEPOSIT2;
cmd.Parameters.Add("@CASHDEPOSIT3", SqlDbType.Int).Value = rEPORT.CASHDEPOSIT3;
cmd.Parameters.Add("@CASHDEPOSIT4", SqlDbType.Int).Value = rEPORT.CASHDEPOSIT4;
cmd.Parameters.Add("@CASHDEPOSIT5", SqlDbType.Int).Value = rEPORT.CASHDEPOSIT5;
cmd.Parameters.Add("@CHECKDEPOSIT1", SqlDbType.Int).Value = rEPORT.CHECKDEPOSIT1;
cmd.Parameters.Add("@CHECKDEPOSIT2", SqlDbType.Int).Value = rEPORT.CHECKDEPOSIT2;
cmd.Parameters.Add("@CHECKDEPOSIT3", SqlDbType.Int).Value = rEPORT.CHECKDEPOSIT3;
cmd.Parameters.Add("@CHECKDEPOSIT4", SqlDbType.Int).Value = rEPORT.CHECKDEPOSIT4;
cmd.Parameters.Add("@CHECKDEPOSIT5", SqlDbType.Int).Value = rEPORT.CHECKDEPOSIT5;
cmd.Parameters.Add("@CHECKDEPOSIT6", SqlDbType.Int).Value = rEPORT.CHECKDEPOSIT6;
cmd.Parameters.Add("@CHECKDEPOSIT7", SqlDbType.Int).Value = rEPORT.CHECKDEPOSIT7;
cmd.Parameters.Add("@CHECKDEPOSIT8", SqlDbType.Int).Value = rEPORT.CHECKDEPOSIT8;
cmd.Parameters.Add("@CHECKDEPOSIT9", SqlDbType.Int).Value = rEPORT.CHECKDEPOSIT9;
cmd.Parameters.Add("@CHECKDEPOSIT10", SqlDbType.Int).Value = rEPORT.CHECKDEPOSIT10;
cmd.Parameters.Add("@CHECKDEPOSIT11", SqlDbType.Int).Value = rEPORT.CHECKDEPOSIT11;
cmd.Parameters.Add("@CHECKDEPOSIT12", SqlDbType.Int).Value = rEPORT.CHECKDEPOSIT12;
cmd.Parameters.Add("@CASHTRANSFER1", SqlDbType.Int).Value = rEPORT.CASHTRANSFER1;
cmd.Parameters.Add("@CASHTRANSFER1REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHTRANSFER1REMARKS;
cmd.Parameters.Add("@CASHTRANSFER2", SqlDbType.Int).Value = rEPORT.CASHTRANSFER2;
cmd.Parameters.Add("@CASHTRANSFER2REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHTRANSFER2REMARKS;
cmd.Parameters.Add("@CASHTRANSFER3", SqlDbType.Int).Value = rEPORT.CASHTRANSFER3;
cmd.Parameters.Add("@CASHTRANSFER3REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHTRANSFER3REMARKS;
cmd.Parameters.Add("@CASHTRANSFER4", SqlDbType.Int).Value = rEPORT.CASHTRANSFER4;
cmd.Parameters.Add("@CASHTRANSFER4REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHTRANSFER4REMARKS;
cmd.Parameters.Add("@CASHTRANSFER5", SqlDbType.Int).Value = rEPORT.CASHTRANSFER5;
cmd.Parameters.Add("@CASHTRANSFER5REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHTRANSFER5REMARKS;
cmd.Parameters.Add("@CASHTRANSFER6", SqlDbType.Int).Value = rEPORT.CASHTRANSFER6;
cmd.Parameters.Add("@CASHTRANSFER6REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHTRANSFER6REMARKS;
cmd.Parameters.Add("@CASHTRANSFER7", SqlDbType.Int).Value = rEPORT.CASHTRANSFER7;
cmd.Parameters.Add("@CASHTRANSFER7REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHTRANSFER7REMARKS;
cmd.Parameters.Add("@CASHTRANSFER8", SqlDbType.Int).Value = rEPORT.CASHTRANSFER8;
cmd.Parameters.Add("@CASHTRANSFER8REMARKS", SqlDbType.VarChar).Value = rEPORT.CASHTRANSFER8REMARKS;
cmd.Parameters.Add("@FEDILITYDEPOSIT", SqlDbType.Int).Value = rEPORT.FEDILITYDEPOSIT;
cmd.Parameters.Add("@CHECKFREEPAYDEPOSIT", SqlDbType.Int).Value = rEPORT.CHECKFREEPAYDEPOSIT;
cmd.Parameters.Add("@CONVPAYDEPOSIT", SqlDbType.Int).Value = rEPORT.CONVPAYDEPOSIT;
cmd.Parameters.Add("@WUPAYOUT", SqlDbType.Int).Value = rEPORT.WUPAYOUT;
cmd.Parameters.Add("@CREDITCARD", SqlDbType.Int).Value = rEPORT.CREDITCARD;
cmd.Parameters.Add("@EXPENSES", SqlDbType.Int).Value = rEPORT.EXPENSES;
cmd.Parameters.Add("@TOTALCASHOUT", SqlDbType.Int).Value = rEPORT.TOTALCASHOUT;
cmd.Parameters.Add("@TOTALBALANCE", SqlDbType.Int).Value = rEPORT.TOTALBALANCE;
cmd.Parameters.Add("@ACTUALBALACE", SqlDbType.Int).Value = rEPORT.ACTUALBALACE;
cmd.Parameters.Add("@SHORTOVER", SqlDbType.Int).Value = rEPORT.SHORTOVER;
cmd.Parameters.Add("@EMP_ID", SqlDbType.Int).Value = rEPORT.EMP_ID;
cmd.Parameters.Add("@STATION_ID", SqlDbType.Int).Value = rEPORT.STATION_ID;
cmd.Parameters.Add("@SHIFT_ID", SqlDbType.Int).Value = rEPORT.SHIFT_ID;
cmd.Parameters.Add("@SHIFTOPEN", SqlDbType.DateTime).Value = rEPORT.SHIFTOPEN;
cmd.Parameters.Add("@SHIFTCLOSE", SqlDbType.DateTime).Value = rEPORT.SHIFTCLOSE;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
