private void ConditionControlDeleted(object sender, EventArgs e)
{
JobCardTaskControl control = (JobCardTaskControl)sender;
JobCardTask cond = control.JobCardTask;
if (cond.ItemId > 0 && MessageBox.Show("Do you really want to delete Job Card Task?", "Deleting confirmation", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
//если информация о состоянии сохранена в БД
//и получен положительный ответ на ее удаление
try
{
GlobalObjects.CasEnvironment.NewKeeper.Delete(cond);
}
catch (Exception ex)
{
Program.Provider.Logger.Log("Error while removing data", ex);
}
flowLayoutPanelMain.Controls.Remove(control);
control.Deleted -= ConditionControlDeleted;
control.Dispose();
}
else if (cond.ItemId <= 0)
{
flowLayoutPanelMain.Controls.Remove(control);
control.Deleted -= ConditionControlDeleted;
control.Dispose();
}
}
public int UpdateJobCardTask(JobCardTask objJobCardTask)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = @"UPDATE JobCardTask SET JobCardId = @JobCardId ,JobCardTaskMasterId = @JobCardTaskMasterId ,SlNo = @SlNo ,CreatedBy = @CreatedBy,CreatedDate = @CreatedDate OUTPUT INSERTED.JobCardTaskId WHERE JobCardTaskId = @JobCardTaskId";
var id = connection.Execute(sql, objJobCardTask);
return(id);
}
}
/*
* Бортовая книга воздушного судна
*/
/*
* Программа по обслуживанию
*/
/*
*
*/
/*
* Поставщики
*/
/*
* Закупочные Ордера
*/
#region public void Publish(PurchaseOrder po, DateTime date)
#endregion
/*
* Ордера запросов на поставку
*/
/*
* Рабочие пакеты
*/
/*
* Audit
*/
/*
* Cas3Maintenance
*/
/*
* SMS
*/
/*
* SMS
*/
/*
* Job cards
*/
#region public void Save(JobCardTask smsEvent)
/// <summary>
/// Сохраняет событие системы безопасности полетов
/// </summary>
/// <param name="jobCardTask"></param>
public void Save(JobCardTask jobCardTask)
{
if (jobCardTask == null)
{
return;
}
Save((BaseEntityObject)jobCardTask);
foreach (JobCardTask eventCondition in jobCardTask.Tasks)
{
eventCondition.JobCard = jobCardTask.JobCard;
eventCondition.ParentTask = jobCardTask;
Save(eventCondition);
}
}
public int InsertJobCardTask(JobCardTask objJobCardTask, IDbConnection connection, IDbTransaction trn)
{
try
{
string sql = @"insert into JobCardTask(JobCardId,JobCardTaskMasterId,SlNo,EmployeeId,TaskDate,Hours,ActualHours,CreatedBy,CreatedDate,OrganizationId) Values
(@JobCardId,@JobCardTaskId,@SlNo,NULLIF(@EmployeeId, 0),@TaskDate,@Hours,@ActualHours,@CreatedBy,@CreatedDate,@OrganizationId);
SELECT CAST(SCOPE_IDENTITY() as int)";
var id = connection.Query <int>(sql, objJobCardTask, trn).Single();
return(id);
}
catch (Exception ex)
{
return(0);
}
}
public ActionResult JobCardReport(int Id)
{
ReportDocument rd = new ReportDocument();
DataSet ds = new DataSet();
ds.Tables.Add("Head");
ds.Tables.Add("Items");
//-------HEAD
ds.Tables["Head"].Columns.Add("JobCardNo");
ds.Tables["Head"].Columns.Add("InternalJobCardNo");
ds.Tables["Head"].Columns.Add("JobCardDate");
ds.Tables["Head"].Columns.Add("EDC");
ds.Tables["Head"].Columns.Add("SaleOrderRefNo");
ds.Tables["Head"].Columns.Add("CustomerName");
ds.Tables["Head"].Columns.Add("CustomerPhone");
ds.Tables["Head"].Columns.Add("CustomerContactPerson");
ds.Tables["Head"].Columns.Add("Unit");
ds.Tables["Head"].Columns.Add("Customer");
ds.Tables["Head"].Columns.Add("Technician");
ds.Tables["Head"].Columns.Add("ChasisNo");
ds.Tables["Head"].Columns.Add("TaskDate");
ds.Tables["Head"].Columns.Add("VModel");
ds.Tables["Head"].Columns.Add("DoorNo");
ds.Tables["Head"].Columns.Add("Street");
ds.Tables["Head"].Columns.Add("State");
ds.Tables["Head"].Columns.Add("Country");
ds.Tables["Head"].Columns.Add("Currency");
ds.Tables["Head"].Columns.Add("Phone");
ds.Tables["Head"].Columns.Add("Fax");
ds.Tables["Head"].Columns.Add("Email");
ds.Tables["Head"].Columns.Add("Zip");
ds.Tables["Head"].Columns.Add("OrganizationName");
ds.Tables["Head"].Columns.Add("Image1");
ds.Tables["Head"].Columns.Add("Box");
ds.Tables["Head"].Columns.Add("Complaints");
ds.Tables["Head"].Columns.Add("BoxMake");
ds.Tables["Head"].Columns.Add("BoxNo");
ds.Tables["Head"].Columns.Add("FreezerMake");
ds.Tables["Head"].Columns.Add("FreezerModel");
ds.Tables["Head"].Columns.Add("VehicleMake");
ds.Tables["Head"].Columns.Add("Accessories");
ds.Tables["Head"].Columns.Add("CreatedUser");
ds.Tables["Head"].Columns.Add("CreateSignature");
ds.Tables["Head"].Columns.Add("CreatedDes");
ds.Tables["Head"].Columns.Add("isProjectBased");
ds.Tables["Head"].Columns.Add("isService");
ds.Tables["Head"].Columns.Add("UnitDetails");
//-------DT
ds.Tables["Items"].Columns.Add("TaskDate");
ds.Tables["Items"].Columns.Add("Employee");
ds.Tables["Items"].Columns.Add("Description");
//ds.Tables["Items"].Columns.Add("StartTime");
//ds.Tables["Items"].Columns.Add("EndTime");
ds.Tables["Items"].Columns.Add("Hours");
JobCardRepository repo = new JobCardRepository();
var Head = repo.GetJobCardHD(Id, OrganizationId);
DataRow dr = ds.Tables["Head"].NewRow();
dr["JobCardNo"] = Head.JobCardNo;
dr["InternalJobCardNo"] = Head.InternalJobCardNo;
dr["JobCardDate"] = Head.JobCardDate.ToString("dd-MMM-yyyy");
dr["EDC"] = Head.RequiredDate.ToString("dd-MMM-yyyy");
dr["SaleOrderRefNo"] = Head.RegistrationNo;
dr["CustomerName"] = Head.CustomerName;
dr["CustomerPhone"] = Head.CPhone;
dr["CustomerContactPerson"] = Head.ContactPerson;
dr["Customer"] = Head.Customer;
dr["Unit"] = Head.FreezerUnitName;
dr["ChasisNo"] = Head.RegistrationNo;
//dr["TaskDate"] = Head.TaskDate;
dr["VModel"] = Head.VehicleModelName;
dr["Technician"] = Head.Technician;
dr["DoorNo"] = Head.DoorNo;
dr["Street"] = Head.Street;
dr["State"] = Head.State;
dr["Country"] = Head.CountryName;
dr["Currency"] = Head.CurrencyName;
dr["Phone"] = Head.Phone;
dr["Fax"] = Head.Fax;
dr["Email"] = Head.Email;
// dr["ContactPerson"] = Head.ContactPerson;
dr["Zip"] = Head.Zip;
dr["OrganizationName"] = Head.OrganizationName;
dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1;
dr["Box"] = Head.BoxName;
dr["Complaints"] = Head.Complaints;
dr["BoxMake"] = Head.BoxMake;
dr["BoxNo"] = Head.BoxNo;
dr["FreezerMake"] = Head.FreezerMake;
dr["FreezerModel"] = Head.FreezerModel;
dr["VehicleMake"] = Head.VehicleMake;
dr["Accessories"] = Head.Accessories;
dr["CreatedUser"] = Head.CreatedUser;
dr["CreateSignature"] = Server.MapPath("~/App_Images/") + Head.CreatedUsersig;
dr["CreatedDes"] = Head.CreatedDes;
dr["isProjectBased"] = Head.isProjectBased;
dr["isService"] = Head.isService;
dr["UnitDetails"] = Head.UnitDetails;
ds.Tables["Head"].Rows.Add(dr);
JobCardTaskRepository repo1 = new JobCardTaskRepository();
var Items = repo1.GetJobCardDT(Id);
foreach (var item in Items)
{
var JCItem = new JobCardTask
{
TaskDate = item.TaskDate,
Employee = item.Employee,
JobCardTaskName = item.JobCardTaskName,
//StartTime = item.StartTime,
//EndTime = item.EndTime,
Hours = item.Hours
};
DataRow dri = ds.Tables["Items"].NewRow();
dri["TaskDate"] = JCItem.TaskDate.ToString("dd-MMM-yyyy");
dri["Employee"] = JCItem.Employee;
dri["Description"] = JCItem.JobCardTaskName;
//dri["StartTime"] = JCItem.StartTime;
//dri["EndTime"] = JCItem.EndTime;
dri["Hours"] = JCItem.Hours;
ds.Tables["Items"].Rows.Add(dri);
}
if (Items.Count >= 0)
{
int n = 23 - Items.Count;
for (int i = 0; i <= n; i++)
{
DataRow dri = ds.Tables["Items"].NewRow();
dri["TaskDate"] = "";
dri["Employee"] = "";
dri["Description"] = "";
//dri["StartTime"] = JCItem.StartTime;
//dri["EndTime"] = JCItem.EndTime;
dri["Hours"] = "";
ds.Tables["Items"].Rows.Add(dri);
}
}
if (Head.isProjectBased == 0)
{
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "JobCard.rpt"));
}
else
{
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "JobCard_Project.rpt"));
}
ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "JobCard.xml"), XmlWriteMode.WriteSchema);
rd.SetDataSource(ds);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf"));//, String.Format("JobCard{0}.pdf", Id.ToString()));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Контрол редактирует данные о задаче рабочей карты
/// </summary>
public JobCardTaskControl(JobCardTask runup)
: this()
{
AttachedObject = runup;
}
