public static StiReport ShowReportList(List <DraftModel> draftModels)
{
var mainReport = new StiReport();
mainReport.Load(Application.StartupPath + "\\ReportList.mrt");
DraftCrud draftCrud = new DraftCrud();
List <draftReportObj> data = new List <draftReportObj>();
int SumOfValue = 0;
foreach (var item in draftModels)
{
draftReportObj itemrr = new draftReportObj();
string finalCarTage = CartTagFunc(item.CarTag);
itemrr.DraftReports = " کامیون " + getTrucksType().Where(z => z.ID == Int32.Parse(item.TruckID)).FirstOrDefault().Name + " به شماره پلاک " + finalCarTage + " جهت حمل " + item.TypeID + " به مقدار " + item.Value + "تن،از مبدا " + item.Origin + " به مقصد " + item.Destination + " به شماره " + item.Number + " تاریخ " + item.Date;
data.Add(itemrr);
SumOfValue += item.Value;
}
mainReport.RegBusinessObject("DraftReports", data);
StiText Part1 = new StiText();
Part1 = (StiText)mainReport.GetComponentByName("TxtSumValue");
Part1.Text = "مجموع کل حواله ها برابر با " + SumOfValue + " تن است";
return(mainReport);
}
private void DraftRegister_Load(object sender, EventArgs e)
{
UsersCrud usersCrud = new UsersCrud();
UniqueCrud uniqueCrud = new UniqueCrud();
uniqueModel = uniqueCrud.GetLastUnique();
var users = usersCrud.findUsers();
txtUserID.DisplayMember = "Name";
txtUserID.ValueMember = "ID";
txtDate.Text = CommonUtils.ConvertMiladiToPersianDate(DateTime.Now.ToShortDateString());
foreach (var item in users)
{
var model = new ItemModel();
model.Name = item.name + " " + item.family;
model.ID = item.ID;
txtUserID.Items.Add(model);
}
txtTruck.DisplayMember = "Name";
txtTruck.ValueMember = "ID";
foreach (var item in CommonUtils.getTrucksType())
{
txtTruck.Items.Add(item);
}
if (isForUpdate == true)
{
btnUpdate.Enabled = true;
btnRegister.Enabled = false;
DraftCrud draftCrud = new DraftCrud();
var draft = draftCrud.findDraftByID(DraftID);
setElementsValue(draft);
}
if (isForUpdate == false)
{
fillForRegisterLoad();
}
}
private void searchGrid(int page = 0)
{
var Name = txtNumber.Text;
var Family = txtManagement.Text;
var UserName = txtFromDate.Text;
var userService = new DraftCrud();
var model = new DraftModel();
model.Number = txtNumber.Text;
model.Management = txtManagement.Text;
model.Date = txtFromDate.Text;
model.CarTag = txtCarTag.Text;
model.Driver = txtDriver.Text;
model.Origin = txtOrigin.Text;
model.Destination = txtDestination.Text;
resultDrafts = userService.findDrafts(model, page, txtFromDate.Text, txtToDate.Text);
if (resultDrafts == null)
{
btnNext.Enabled = false;
}
grdDrafts.DataSource = resultDrafts;
if (resultDrafts != null)
{
grdDrafts.Columns[0].HeaderText = "شناسه حواله";
grdDrafts.Columns[1].HeaderText = "شماره حواله";
grdDrafts.Columns[2].HeaderText = "سریال";
grdDrafts.Columns[3].HeaderText = "مدیریت";
grdDrafts.Columns[4].HeaderText = "کامیون";
grdDrafts.Columns[5].Visible = false;
grdDrafts.Columns[6].HeaderText = "پلاک";
grdDrafts.Columns[7].HeaderText = "راننده";
grdDrafts.Columns[8].HeaderText = "گواهینامه";
grdDrafts.Columns[9].HeaderText = "نوع";
grdDrafts.Columns[10].Visible = false;
grdDrafts.Columns[11].HeaderText = "مقدار";
grdDrafts.Columns[12].HeaderText = "مبدا";
grdDrafts.Columns[13].HeaderText = "مقصد";
grdDrafts.Columns[14].HeaderText = "شناسه کاربر";
grdDrafts.Columns[15].HeaderText = "تاریخ";
}
}
private void btnPrintAll_Click(object sender, EventArgs e)
{
var Name = txtNumber.Text;
var Family = txtManagement.Text;
var UserName = txtFromDate.Text;
var userService = new DraftCrud();
var model = new DraftModel();
model.Serial = txtNumber.Text;
model.Management = txtManagement.Text;
model.Date = txtFromDate.Text;
model.CarTag = txtCarTag.Text;
model.Driver = txtDriver.Text;
model.Origin = txtOrigin.Text;
model.Destination = txtDestination.Text;
var data = userService.findAllDrafts(model, page, txtFromDate.Text, txtToDate.Text);
var stiReport = CommonUtils.ShowReportList(data);
stiReport.Show();
}
private void button2_Click(object sender, EventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.InitialDirectory = @"C:\";
openFileDialog.Title = "بارگزاری نسخه دیتابیس";
openFileDialog.Filter = "Database File (*.db)|*.db";
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
string path = openFileDialog.FileName;
var resultMsg = MessageBox.Show("آیا میخواهید عملیات بارگزاری انجام شود?", "بارگزارش", MessageBoxButtons.YesNo);
if (resultMsg == DialogResult.Yes)
{
DraftCrud draftCrud = new DraftCrud();
var draftRecords = draftCrud.GetDrafts(path);
draftCrud.saveIntoDraftTable(draftRecords);
draftCrud.UpdateDraftTabe(path);
UsersCrud usersCrud = new UsersCrud();
var userRecords = usersCrud.GetUsers(path);
usersCrud.saveIntoDraftTable(userRecords);
MessageBox.Show("عملیات بارگذاری با موفقیت تکمیل گردید.");
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtCarTag.Text == "" || txtCertificateDriver.Text == "" || txtDate.Text == "" || txtDestination.Text == "" || txtDriver.Text == "" ||
txtManagement.Text == "" || txtNumber.Text == "" || txtOrigin.Text == "" || txtSerial.Text == "" || txtTruck.Text == "" || txtType.Text == "" ||
txtUserID.SelectedItem == null || txtValue.Text == "")
{
MessageBox.Show("اطلاعات را به صورت کامل وارد نمایید.", "خطا در ورود اطلاعات", MessageBoxButtons.OK);
return;
}
if (ChekDateIsValid() == false)
{
return;
}
if (CheckIsCarTagValid() == false)
{
return;
}
var paramValues = bindFields();
if (MessageBox.Show("آیا اطلاعات ذخیره گردد. ", "ثبت اطلاعات", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
DbContext context = new DbContext();
context.UpdateUser(DatabaseConstantData.DraftTable, DraftID, paramValues);
MessageBox.Show("اطلاعات با موفقیت ثبت گردید", "ثبت اطلاعات", MessageBoxButtons.OK);
DraftCrud draftCrud = new DraftCrud();
var draft = draftCrud.findDraftByID(DraftID);
var stiReport = CommonUtils.ShowReport(draft.ID);
stiReport.Show();
}
else
{
return;
}
}
public static StiReport ShowReport(int ID)
{
var stiReportResearcher = new StiReport();
DraftCrud draftCrud = new DraftCrud();
var findedDraft = draftCrud.findDraftByID(ID);
stiReportResearcher = new StiReport();
stiReportResearcher.Load(Application.StartupPath + "\\Report.mrt");
StiText Part1 = new StiText();
Part1 = (StiText)stiReportResearcher.GetComponentByName("Part1");
Part1.Text = "مدیریت محترم : " + findedDraft.Origin;
StiText txtDate = new StiText();
txtDate = (StiText)stiReportResearcher.GetComponentByName("txtDate");
txtDate.Text = "تاریخ : " + findedDraft.Date;
StiText txtNumber = new StiText();
txtNumber = (StiText)stiReportResearcher.GetComponentByName("txtNumber");
txtNumber.Text = "شماره گزارش : " + findedDraft.Number;
StiText Part2 = new StiText();
Part2 = (StiText)stiReportResearcher.GetComponentByName("Part2");
string carrTag = findedDraft.CarTag;
string finalCarTag = CartTagFunc(carrTag);
Part2.Text = " کامیون " + getTrucksType().Where(z => z.ID == Int32.Parse(findedDraft.TruckID)).FirstOrDefault().Name + " به شماره پلاک " + finalCarTag + " به رانندگی " + findedDraft.Driver + " شماره گواهینامه " + findedDraft.CertificateDriver + " جهت حمل " + findedDraft.TypeID + " به مقدار " + findedDraft.Value + " تن به مقصد " + findedDraft.Destination + " حضورتان معرفی میگردد";
return(stiReportResearcher);
}
private void btnRegister_Click(object sender, EventArgs e)
{
if (txtCarTag.Text == "" || txtCertificateDriver.Text == "" || txtDate.Text == "" || txtDestination.Text == "" || txtDriver.Text == "" ||
txtManagement.Text == "" || txtNumber.Text == "" || txtOrigin.Text == "" || txtSerial.Text == "" || txtTruck.Text == "" || txtType.Text == "" ||
txtUserID.SelectedItem == null || txtValue.Text == "")
{
MessageBox.Show("اطلاعات را به صورت کامل وارد نمایید.", "خطا در ورود اطلاعات", MessageBoxButtons.OK);
return;
}
if (ChekDateIsValid() == false)
{
return;
}
if (CheckIsCarTagValid() == false)
{
return;
}
var paramValues = bindFields();
if (MessageBox.Show("آیا اطلاعات ذخیره گردد. ", "ثبت اطلاعات", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
DbContext context = new DbContext();
context.InsertData(DatabaseConstantData.DraftTable, paramValues);
MessageBox.Show("اطلاعات با موفقیت ثبت گردید", "ثبت اطلاعات", MessageBoxButtons.OK);
DraftCrud draftCrud = new DraftCrud();
var draft = draftCrud.findDraftByNumber(txtNumber.Text);
var stiReport = CommonUtils.ShowReport(draft.ID);
stiReport.Show();
List <TextBox> textBoxes = new List <TextBox>();
textBoxes.Add(txtCarTag);
textBoxes.Add(txtCertificateDriver);
textBoxes.Add(txtDate);
textBoxes.Add(txtDestination);
textBoxes.Add(txtDriver);
textBoxes.Add(txtManagement);
textBoxes.Add(txtNumber);
textBoxes.Add(txtOrigin);
textBoxes.Add(txtSerial);
textBoxes.Add(txtValue);
setNullToTextBox(textBoxes);
if (DateTime.Now.ToShortDateString() != CommonUtils.ConvertPersianToMiladiDate(uniqueModel.Date).ToShortDateString())
{
uniqueModel.UniquID = 1;
}
else
{
uniqueModel.UniquID++;
}
var paramsGenerate = bindFieldsGenerate(uniqueModel.UniquID);
context.UpdateGenerate(DatabaseConstantData.GenerateTable, uniqueModel.ID, paramsGenerate);
UniqueCrud uniqueCrud = new UniqueCrud();
uniqueModel = uniqueCrud.GetLastUnique();
fillForRegisterLoad();
}
else
{
return;
}
}
