//Background processes
//process files from Config.xml
private void MyWorker_DoWork(object Sender, System.ComponentModel.DoWorkEventArgs e)
{
DelegateUpdateLabel Upd_Del_label = new DelegateUpdateLabel(UpdateLabel);
DelegateUpdateFileList Upd_file_list = new DelegateUpdateFileList(UpdateFileList);
DelegateUpdateUpdateProgressBar upd_prog_bar = new DelegateUpdateUpdateProgressBar(UpdateProgressBar);
processes proc_config = new processes();
proc_config.process_config(e.Argument.ToString());
int file_count = proc_config.proc_files.Count;
label1.Dispatcher.BeginInvoke(System.Windows.Threading.DispatcherPriority.Normal, Upd_Del_label, file_count);
ProgressBar.Dispatcher.BeginInvoke(System.Windows.Threading.DispatcherPriority.Normal, upd_prog_bar, 0);
for (int i = 0; i < file_count; i++)
{
proc_config.process_file(proc_config.proc_files[i]);
proc_config.proc_files[i].processed = true;
double perc = (Convert.ToDouble(i + 1) / Convert.ToDouble(file_count)) * 100;
lbl_progress.Dispatcher.BeginInvoke(System.Windows.Threading.DispatcherPriority.Normal, Upd_Del_label, file_count - (i + 1));
ProgressBar.Dispatcher.BeginInvoke(System.Windows.Threading.DispatcherPriority.Normal, upd_prog_bar, perc);
colSet.Dispatcher.BeginInvoke(System.Windows.Threading.DispatcherPriority.Normal, Upd_file_list, proc_config.proc_files[(i)]);
}
e.Cancel = false;
return;
}
private static void _updateprocesses(ElearnDBDataContext db, int userid, string partcode, int wordid, int?index)
{
index = index ?? 0;
var hasexistid = db.processes.SingleOrDefault(user => user.user_id == userid);
if (hasexistid == null)
{
processes insertone = new processes
{
user_id = userid,
part_code = partcode,
eword_id = wordid,
process_index = index,
oralsentence_id = null
};
db.processes.InsertOnSubmit(insertone);
}
else
{
hasexistid.part_code = partcode;
hasexistid.eword_id = wordid;
hasexistid.process_index = index;
hasexistid.oralsentence_id = null;
}
db.SubmitChanges();
}
// GET: api/Occurrence
//public IEnumerable<string> Get()
//{
// return new string[] { "value1", "value2" };
//}
//// GET: api/Occurrence/5
//public string Get(int id)
//{
// return "value";
//}
// POST: api/Occurrence
public IHttpActionResult Post([FromBody] dynamic value)
{
using (testeftEntities db = new testeftEntities())
{
occurrences o = new occurrences();
o.station_id = value.station_id;
o.occurred_when = value.occurred_when;
foreach (var proc in value.proc)
{
processes p = new processes();
p.name = proc;
o.processes.Add(p);
}
db.occurrences.Add(o);
db.SaveChanges();
return(Ok(o.id));
}
}
/*
* Andres Alberto Yepes
* 28-10-2016
* ***************************************************************************************************************
* función encargada crear un caso de gestión desembolso.
*
* */
private GestionDesembolsoResponse crearCasoDesembolso(GestionDesembolsoRequest notificacion)
{
BizAgiWSParam <M_CAT_GestionDesembolso> param = new BizAgiWSParam <M_CAT_GestionDesembolso>(Properties.Resources.DominioDomain, Properties.Resources.UsuarioCrearCaso);
BizAgiWSParamCase <M_CAT_GestionDesembolso> caso = new BizAgiWSParamCase <M_CAT_GestionDesembolso>(Properties.Resources.ProcesoDesembolso);
caso.Entities.InfoCaso = new M_CAT_GestionDesembolso();
caso.Entities.InfoCaso.OidInformacionDesembolso.SNumeroTramite = notificacion.InformacionDesembolso.NumeroTramite;
caso.Entities.InfoCaso.OidInformacionDesembolso.OidTrackingDesembolso.SCodigoEstacion = notificacion.InformacionEstacion.CodigoEstacion;
caso.Entities.InfoCaso.OidInformacionDesembolso.OidTrackingDesembolso.SIdentificacionEstacion = notificacion.InformacionEstacion.IdentificacionEstacion;
caso.Entities.InfoCaso.OidInformacionDesembolso.OidTrackingDesembolso.OidTipoDocumentoEstac.SCodigo = notificacion.InformacionEstacion.TipoIdentificacionEstacion.Codigo;
caso.Entities.InfoCaso.OidInformacionDesembolso.OidTrackingDesembolso.IRuta = notificacion.RutaActual;
caso.Entities.InfoCaso.OidInformacionDesembolso.OidTrackingDesembolso.IEtapa = notificacion.EtapaActual;
caso.Entities.InfoCaso.OidInformacionDesembolso.OidTrackingDesembolso.DFechaNotificacion = notificacion.FechaNotificacion;
if (notificacion.InformacionDesembolso.CausalReintegro != null)
{
caso.Entities.InfoCaso.OidInformacionDesembolso.OidTrackingDesembolso.OidCausalReintegro.SCodigo = notificacion.InformacionDesembolso.CausalReintegro.Codigo;
}
param.Cases[0] = caso;
BizagiSOALayerOperations <BizAgiWSParam <M_CAT_GestionDesembolso> > ejecutar = new BizagiSOALayerOperations <BizAgiWSParam <M_CAT_GestionDesembolso> >();
ejecutar.Url = ProxyUtils.GetServiceEndpoint("URLWorkFlowEngine");
processes crearCasoResp = ejecutar.createCase2(param);
return(getRespuestaBO(crearCasoResp, EnumSOALayerAction.CreateCase));
}
public void CreateCard()
{
var p = new processes(card_mo7sabi.card.process);
inserttype(card_mo7sabi.part.num_type, card_mo7sabi.cost, Data);
Data["E8"] = p.Name;
Data["E11"] = card_mo7sabi.subject;
Data["E13"] = "الحصة رقم " + card_mo7sabi.part.num + " : " + card_mo7sabi.part.Name;
Data["E15"] = " مؤسسة : " + card_mo7sabi.client.Name;
///////////////// start top section ////////////
Data["Z4"] = p.code_.NumProsess[0] + "";
Data["Y4"] = p.code_.NumProsess[1] + "";
Data["R4"] = p.code_.Subject + "";
Data["Q4"] = p.code_.chapter[0] + "";
Data["P4"] = p.code_.chapter[1] + "";
Data["O4"] = p.code_.chapter[2] + "";
Data["N4"] = p.code_.NK[2] + "";
Data["M4"] = p.code_.NK[0].ToString().ToUpper();
Data["L4"] = p.code_.NK[1].ToString().ToUpper();
string year = card_mo7sabi.card.year1.year1.Year.ToString();
Data["G4"] = year.ElementAt(2) + "";
Data["F4"] = year.ElementAt(3) + "";
string a = card_mo7sabi.card.num + "";
switch (a.Length)
{
case 1:
Data["J4"] = "0";
Data["I4"] = "0";
Data["H4"] = a.ElementAt(0) + "";
break;
case 2:
Data["J4"] = "0";
Data["I4"] = a.ElementAt(0) + "";
Data["H4"] = a.ElementAt(1) + "";
break;
case 3:
Data["J4"] = a.ElementAt(0) + "";
Data["I4"] = a.ElementAt(1) + "";
Data["H4"] = a.ElementAt(2) + "";
break;
}
/////////////////// finsh top section //////////////
Data["G32"] = card_mo7sabi.cost + "";
Data["E36"] = card_mo7sabi.cost + "";
Data["B36"] = card_mo7sabi.oldCost + "";
Data["L36"] = (card_mo7sabi.oldCost - card_mo7sabi.cost) + "";
ExcelHlper excelHlper = new ExcelHlper("mo7asabi_Template", new string[] { "p" });
excelHlper.EditMenyCell("p", Data);
excelHlper.SaveAs(card_mo7sabi.card.location);
excelHlper.Close();
}
public void CreateCard()
{
var p = new processes(card_kanoni.card.process);
inserttype(card_kanoni.part.num_type, card_kanoni.part.Cost, Data);
Data["F9"] = p.Name;
Data["F11"] = " الإلتزام القانوني للمبلغ الملتزم به غير المسدد للعملية الى غاية:" + " 31/ 12/ " + card_kanoni.part.process.date.Year;
Data["F14"] = "مؤسسة : " + card_kanoni.client.Name;
///////////////// start top section ////////////
Data["Z4"] = p.code_.NumProsess[0] + "";
Data["Y4"] = p.code_.NumProsess[1] + "";
Data["R4"] = p.code_.Subject + "";
Data["Q4"] = p.code_.chapter[0] + "";
Data["P4"] = p.code_.chapter[1] + "";
Data["O4"] = p.code_.chapter[2] + "";
Data["N4"] = p.code_.NK[2] + "";
Data["M4"] = p.code_.NK[0].ToString().ToUpper();
Data["L4"] = p.code_.NK[1].ToString().ToUpper();
string year = card_kanoni.card.year1.year1.Year.ToString();
Data["G4"] = year.ElementAt(2) + "";
Data["F4"] = year.ElementAt(3) + "";
string a = card_kanoni.card.num + "";
switch (a.Length)
{
case 1:
Data["J4"] = "0";
Data["I4"] = "0";
Data["H4"] = a.ElementAt(0) + "";
break;
case 2:
Data["J4"] = "0";
Data["I4"] = a.ElementAt(0) + "";
Data["H4"] = a.ElementAt(1) + "";
break;
case 3:
Data["J4"] = a.ElementAt(0) + "";
Data["I4"] = a.ElementAt(1) + "";
Data["H4"] = a.ElementAt(2) + "";
break;
}
/////////////////// finsh top section //////////////
Data["G32"] = card_kanoni.part.Cost + "";
Data["E36"] = card_kanoni.part.Cost + "";
ExcelHlper excelHlper = new ExcelHlper("kanoni_Template", new string[] { "p" });
excelHlper.EditMenyCell("p", Data);
excelHlper.SaveAs(card_kanoni.card.location);
excelHlper.Close();
}
public void CreateP1()
{
var p = new processes(card_dafa3.part.process);
inserttype(card_dafa3.part.num_type, card_dafa3.Cost, Data);
Data["E8"] = p.Name;
Data["E11"] = "إلتزام العقد المتعلق ب " + card_dafa3.part.Name;
if (card_dafa3.part.process.parts.ToList().Count == 1 || card_mo7sabi.part.num_type == 7)
{
Data["E13"] = "الحصة رقم " + card_dafa3.part.num + " : " + card_dafa3.part.Name;
}
Data["E15"] = " مؤسسة : " + client.Name;
///////////////// start top section ////////////
Data["Z4"] = p.code_.NumProsess[0] + "";
Data["Y4"] = p.code_.NumProsess[1] + "";
Data["R4"] = p.code_.Subject + "";
Data["Q4"] = p.code_.chapter[0] + "";
Data["P4"] = p.code_.chapter[1] + "";
Data["O4"] = p.code_.chapter[2] + "";
Data["N4"] = p.code_.NK[2] + "";
Data["M4"] = p.code_.NK[0].ToString().ToUpper();
Data["L4"] = p.code_.NK[1].ToString().ToUpper();
string year = card_dafa3.part.card_mo7sabi.ToList().FirstOrDefault().card.year1.year1.Year.ToString();
Data["G4"] = year.ElementAt(2) + "";
Data["F4"] = year.ElementAt(3) + "";
string a = card_dafa3.num + "";
switch (a.Length)
{
case 1:
Data["J4"] = "0";
Data["I4"] = "0";
Data["H4"] = a.ElementAt(0) + "";
break;
case 2:
Data["J4"] = "0";
Data["I4"] = a.ElementAt(0) + "";
Data["H4"] = a.ElementAt(1) + "";
break;
case 3:
Data["J4"] = a.ElementAt(0) + "";
Data["I4"] = a.ElementAt(1) + "";
Data["H4"] = a.ElementAt(2) + "";
break;
}
/////////////////// finsh top section //////////////
Data["G32"] = card_dafa3.Cost + "";
Data["E36"] = card_dafa3.Cost + "";
excel.EditMenyCell("p", Data);
}
public processes performActivity(string xml)
{
WorkflowEngineSOA.WorkflowEngineSOA wfEngine = new WorkflowEngineSOA.WorkflowEngineSOA();
wfEngine.Url = url;
string xmlRespuesta = wfEngine.performActivityAsString(xml);
processes respuesta = SerializerManager.DeserializarTo <processes>(xmlRespuesta);
return(respuesta);
}
public processes createCase2(T param)
{
WorkflowEngineSOA.WorkflowEngineSOA wfEngine = new WorkflowEngineSOA.WorkflowEngineSOA();
wfEngine.Url = url;
string xml = SerializerManager.SerializarToXml <T>(param);
string xmlRespuesta = wfEngine.createCasesAsString(xml);
//XmlDocument respuesta = new XmlDocument();
//respuesta.LoadXml(xmlRespuesta);
processes respuesta = SerializerManager.DeserializarTo <processes>(xmlRespuesta);
return(respuesta);
}
private GestionDesembolsoResponse getRespuestaBO(processes crearCasoResp, EnumSOALayerAction tipoAccion)
{
GestionDesembolsoResponse respServicio = new GestionDesembolsoResponse();
string errorCode = crearCasoResp.process[0].processError.errorCode;
if (errorCode != null && errorCode.Length > 0)
{
respServicio.Codigo = Properties.Resources.ErrorTecnico;
respServicio.ErrorSistema.Codigo = errorCode;
if (crearCasoResp.process[0].processError.errorMessage.Entities == null)
{
respServicio.ErrorSistema.Mensaje = crearCasoResp.process[0].processError.errorMessage.Text[0];
}
else
{
respServicio.ErrorSistema.Mensaje = crearCasoResp.process[0].processError.errorMessage.Entities.ErrorMessage;
}
switch (tipoAccion)
{
case EnumSOALayerAction.CreateCase:
respServicio.Mensaje = Properties.Resources.MsgErrorCreandoCaso;
break;
case EnumSOALayerAction.PerformActivity:
respServicio.Mensaje = Properties.Resources.MsgErrorPerformActivity;
break;
}
}
else
{
respServicio.Codigo = Properties.Resources.CodigoExitoBizagi;
switch (tipoAccion)
{
case EnumSOALayerAction.CreateCase:
respServicio.processId = int.Parse(crearCasoResp.process[0].processId);
respServicio.Mensaje = Properties.Resources.MsgExitoCrearCaso;
respServicio.radNumber = crearCasoResp.process[0].processRadNumber;
break;
case EnumSOALayerAction.PerformActivity:
respServicio.Mensaje = Properties.Resources.MsgExitoPerformaActivity;
break;
}
}
return(respServicio);
}
public void CreateP2()
{
var p = new processes(card_dafa3.part.process);
Dictionary <string, string> Data1 = new Dictionary <string, string>();
Data1["K9"] = DateTime.Now.Year + "";
Data1["A19"] = client.Name;
Data1["A22"] = client.address;
Data1["E19"] = client.num_account;
Data1["E21"] = client.bank;
Data1["E23"] = client.gence;
Data1["J20"] = p.code_.NK[0].ToString().ToUpper() + p.code_.NK[1].ToString().ToUpper() + p.code_.NK[2].ToString().ToUpper();
Data1["K20"] = p.code_.chapter[0].ToString() + p.code_.chapter[1].ToString() + p.code_.chapter[2].ToString();
Data1["M20"] = p.process.date.Year + "";
Data1["G31"] = card_dafa3.alcost;
Data1["R19"] = card_dafa3.tswiya;
excel.EditMenyCell("p2", Data1);
}
/*
* Andres Alberto Yepes
* 06-01-2017
* ***************************************************************************************************************
* función encargada de realizar el perform activity. como base utiliza xslt para realizar la transformación de la información
* recibida en la fachada a la estructura esperada por Bizagi de acuerdo al modelo de datos del proceso. No tiene acoplamiento
* con la estructura del proceso, mas allá que a través de la xslt recibida anteriormente. Utiliza una clase generica para realizar
* el perform activity funcionando como un DTO.
*
* */
private GestionDesembolsoResponse performActivity2(GestionDesembolsoRequest notificacion, InfoCasoDesembolso casoDesembolsoConsultado)
{
XmlDocument request = SerializerManager.SerializarToXmlDocument <GestionDesembolsoRequest>(notificacion);
HUB.BizagiSOAObjects.PeformActivityGeneric.BizAgiWSParam param = new HUB.BizagiSOAObjects.PeformActivityGeneric.BizAgiWSParam();
HUB.BizagiSOAObjects.PeformActivityGeneric.BizAgiWSParamActivityData activity = new HUB.BizagiSOAObjects.PeformActivityGeneric.BizAgiWSParamActivityData();
activity.idCase = casoDesembolsoConsultado.OidTrackingDesembolso.IIdCaso;
activity.taskName = casoDesembolsoConsultado.OidTrackingDesembolso.OidActividadEspera.STaskName;
param.domain = Properties.Resources.DominioFNA;
param.userName = casoDesembolsoConsultado.OidTrackingDesembolso.SNombreUsuarioEstacion;
param.ActivityData = activity;
BizagiSOALayerOperations <HUB.BizagiSOAObjects.PeformActivityGeneric.BizAgiWSParam> ejecutar = new BizagiSOALayerOperations <HUB.BizagiSOAObjects.PeformActivityGeneric.BizAgiWSParam>();
ejecutar.Url = ProxyUtils.GetServiceEndpoint("URLWorkFlowEngine");
string xmlParam = SerializerManager.SerializarToXml(param);
XmlDocument paramDocXML = new XmlDocument();
paramDocXML.LoadXml(xmlParam);
XPathNavigator navigatorParam = paramDocXML.CreateNavigator();
//transforma el request en un xml con la definición de esquema del proceso en Bizagi
string xmlEntities = XMLOperations.XSLTransformation(casoDesembolsoConsultado.OidTrackingDesembolso.OidActividadEspera.STransformacion, request);
XmlDocument docEntitiesXml = new XmlDocument();
docEntitiesXml.LoadXml(xmlEntities);
XPathNavigator navEntities = docEntitiesXml.CreateNavigator();
//crea el nodo de entities
navigatorParam.MoveToChild("BizAgiWSParam", String.Empty);
navigatorParam.AppendChild("<Entities></Entities>");
navigatorParam.MoveToChild("Entities", String.Empty);
//inserta en el nodo entities el xml con el xml transformado por la xslt
navigatorParam.AppendChild(docEntitiesXml.OuterXml);
processes performResp = ejecutar.performActivity(paramDocXML.OuterXml);
return(getRespuestaBO(performResp, EnumSOALayerAction.PerformActivity));
}
public AddCardMo7asabi(processes processes, Action _save, Action con)
{
nowCost = processes.process.NewCost;
list = new List <CommboxItem>();
foreach (part part in processes.process.parts.ToList())
{
item.Add(new ItemPart(part));
}
// save =new Command(async ()=> {
// _save();
/* await Task.Run(() => {
* var card= new Card_mo7sabi(null);
*
* card.CreateCard();
* });
* // con();
*/
// });
}
public static ewords GetNextWord(int userid, processes process)
{
using (var db = new ElearnDBDataContext())
{
ewords nextword = null;
if (_haveprocess(db, userid))
{
nextword = _getnextword(db, process.part_code, process.eword_id);
if (nextword == null)
{
return(null);
}
else
{
_updateprocesses(db, userid, process.part_code, nextword.eword_id, process.process_index + 1);
return(nextword);
}
}
else
{
return(null);
}
}
}
public void CreateCard()
{
var p = new processes(card_sa7ab.card.process);
types types = new types();
foreach (p_sa7ab pr in card_sa7ab.p_sa7ab)
{
types.insert(pr.part.num_type, pr.cost);
}
types.leadData(Data);
Data["F9"] = p.Name;
Data["F11"] = " سحب المبلغ الملتزم به غير المسدد للعملية الى غاية: 31/ 12/ " + p.process.cards.ToList().LastOrDefault().year1.year1.Year;
// Data["F11"] = "أخذ بالحساب رقم للمقرر رقم "+p.process.num+" المؤرخ بتاريخ "+p.process.date.ToShortDateString();
///////////////// start top section ////////////
Data["Z4"] = p.code_.NumProsess[0] + "";
Data["Y4"] = p.code_.NumProsess[1] + "";
Data["R4"] = p.code_.Subject + "";
Data["Q4"] = p.code_.chapter[0] + "";
Data["P4"] = p.code_.chapter[1] + "";
Data["O4"] = p.code_.chapter[2] + "";
Data["N4"] = p.code_.NK[2] + "";
Data["M4"] = p.code_.NK[0].ToString().ToUpper();
Data["L4"] = p.code_.NK[1].ToString().ToUpper();
string year = card_sa7ab.card.year1.year1.Year.ToString();
Data["G4"] = year.ElementAt(2) + "";
Data["F4"] = year.ElementAt(3) + "";
string a = card_sa7ab.card.num + "";
switch (a.Length)
{
case 1:
Data["J4"] = "0";
Data["I4"] = "0";
Data["H4"] = a.ElementAt(0) + "";
break;
case 2:
Data["J4"] = "0";
Data["I4"] = a.ElementAt(0) + "";
Data["H4"] = a.ElementAt(1) + "";
break;
case 3:
Data["J4"] = a.ElementAt(0) + "";
Data["I4"] = a.ElementAt(1) + "";
Data["H4"] = a.ElementAt(2) + "";
break;
}
/////////////////// finsh top section //////////////
Data["G32"] = card_sa7ab.card + "";
Data["E36"] = card_sa7ab.card + "";
Data["B36"] = card_sa7ab.old_cost + "";
Data["L36"] = (card_sa7ab.old_cost + card_sa7ab.cost) + "";
ExcelHlper excelHlper = new ExcelHlper("sa7ab_Template", new string[] { "p" });
excelHlper.EditMenyCell("p", Data);
excelHlper.SaveAs(card_sa7ab.card.location);
excelHlper.Close();
}
public GanttChart GetDailyProduction(string cdate, int lineid) //date format : dd/MM/yyyy
{
DateTime startdate = Convert.ToDateTime(cdate);
DateTime enddate = Convert.ToDateTime(cdate).AddDays(1);
IList <OrderDetail> orderdetail = db.OrderDetails
//.Include(o => o.Line)
.Include(o => o.Product)
//.Include(o => o.Shift)
.Where(o => o.CreatedDate.Year == startdate.Year && o.CreatedDate.Month == startdate.Month && o.CreatedDate.Day == startdate.Day && o.LineId == lineid && o.FinalStatus == 1)
.OrderBy(x => x.OrderId).ToList();
var count = orderdetail.Count;
GanttChart objganttchart = new GanttChart();
objganttchart.type = "gantt";
objganttchart.width = "100%";
objganttchart.height = "120";
objganttchart.dataFormat = "json";
dataSource objdatasource = new dataSource();
//chart
chart objchart = new chart();
objchart.theme = "fusion";
objchart.dateformat = "dd/mm/yyyy hh:mn";
objchart.showTaskLabels = 1;
//task
gtask[] arrtask = new gtask[count];
for (int i = 0; i < count; i++)
{
var objtask = new gtask();
objtask.label = orderdetail[i].Product.ProductDesc;
objtask.processid = "A";
objtask.start = orderdetail[i].OrderStartTime.ToString("dd/MM/yyyy HH:mm");
DateTime endtime = orderdetail[i].OrderEndTime ?? DateTime.Now;
objtask.end = endtime.ToString("dd/MM/yyyy HH:mm");
objtask.color = "#" + orderdetail[i].Product.ProductColor;
objtask.alpha = "85";
arrtask[i] = objtask;
}
gtasks objtasks = new gtasks();
objtasks.task = arrtask;
//processes
processes objprocesses = new processes();
process[] arrprocess = new process[1];
process objprocess = new process();
objprocess.label = orderdetail[0].OrderStartTime.ToString("dd/MM/yyyy");
objprocess.id = "A";
arrprocess[0] = objprocess;
objprocesses.isbold = "1";
objprocesses.process = arrprocess;
//categories
categories[] arrcategories = new categories[1];
categories objcategories = new categories();
objcategories.bgalpha = "0";
//category1
category[] arrcategory1 = new category[1];
category objcategory1 = new category();
objcategory1.start = startdate.ToString("dd/MM/yyyy 06:00");
objcategory1.end = enddate.ToString("dd/MM/yyyy 06:00");
objcategory1.label = "";
arrcategory1[0] = objcategory1;
objcategories.category1 = arrcategory1;
//category
category[] arrcategory = new category[24];
int arrcategorycount = arrcategory.Length;
for (int i = 0; i < arrcategorycount; i++)
{
int k = i + 1;
int stime = 6 + i;
int etime = 6 + k;
int starttime = stime >= 24 ? stime - 24 : stime;
int endtime = etime >= 24 ? etime - 24 : etime;
string startimeformat = starttime.ToString().Length == 1 ? "0" + starttime.ToString() + ":00" : starttime.ToString() + ":00";
string endtimeformat = endtime.ToString().Length == 1 ? "0" + endtime.ToString() + ":00" : endtime.ToString() + ":00";
category objcategory = new category();
objcategory.start = stime >= 24 ? enddate.ToString("dd/MM/yyyy " + startimeformat + "") : startdate.ToString("dd/MM/yyyy " + startimeformat + "");
objcategory.end = stime >= 23 ? enddate.ToString("dd/MM/yyyy " + endtimeformat + "") : startdate.ToString("dd/MM/yyyy " + endtimeformat + "");
objcategory.label = startimeformat;
arrcategory[i] = objcategory;
}
objcategories.category = arrcategory;
arrcategories[0] = objcategories;
objdatasource.chart = objchart;
objdatasource.tasks = objtasks;
objdatasource.processes = objprocesses;
objdatasource.categories = arrcategories;
objganttchart.dataSource = objdatasource;
return(objganttchart);
}
public void CreateCard()
{
var p = new processes(card_7isab.card.process);
types types = new types();
double Allcost = 0;
foreach (part pr in p.process.parts.ToList())
{
types.insert(pr.num_type, pr.Cost);
Allcost += pr.Cost;
}
types.leadData(Data);
Data["F9"] = p.Name;
Data["F11"] = "أخذ بالحساب رقم للمقرر رقم " + p.process.num + " المؤرخ بتاريخ " + p.process.date.ToShortDateString();
///////////////// start top section ////////////
Data["Z4"] = p.code_.NumProsess[0] + "";
Data["Y4"] = p.code_.NumProsess[1] + "";
Data["R4"] = p.code_.Subject + "";
Data["Q4"] = p.code_.chapter[0] + "";
Data["P4"] = p.code_.chapter[1] + "";
Data["O4"] = p.code_.chapter[2] + "";
Data["N4"] = p.code_.NK[2] + "";
Data["M4"] = p.code_.NK[0].ToString().ToUpper();
Data["L4"] = p.code_.NK[1].ToString().ToUpper();
string year = card_7isab.card.year1.year1.Year.ToString();
Data["G4"] = year.ElementAt(2) + "";
Data["F4"] = year.ElementAt(3) + "";
string a = card_7isab.card.num + "";
switch (a.Length)
{
case 1:
Data["J4"] = "0";
Data["I4"] = "0";
Data["H4"] = a.ElementAt(0) + "";
break;
case 2:
Data["J4"] = "0";
Data["I4"] = a.ElementAt(0) + "";
Data["H4"] = a.ElementAt(1) + "";
break;
case 3:
Data["J4"] = a.ElementAt(0) + "";
Data["I4"] = a.ElementAt(1) + "";
Data["H4"] = a.ElementAt(2) + "";
break;
}
/////////////////// finsh top section //////////////
Data["G32"] = Allcost + "";
Data["E36"] = Allcost + "";
Data["L36"] = Allcost + "";
ExcelHlper excelHlper = new ExcelHlper("7isab_Template", new string[] { "p" });
excelHlper.EditMenyCell("p", Data);
excelHlper.SaveAs(card_7isab.card.location);
excelHlper.Close();
}