public static ServiceCrmEvolutionItem GetByCode(entitiesEvolveCentral ctx, string servicecode)
{
var item = new ServiceCrmEvolutionItem();
item = (from i in ctx.ServiceCrmEvolutionItems where i.Code == servicecode where i.IsActive == true select i).FirstOrDefault();
return(item);
}
//public static ServiceItem GetByCode(entitiesEvolveCentral ctx, string clientcode,string servicetypecode)
//{
// var item = new ServiceItem();
// item = (from i in ctx.ServiceItems where i.ClientItem.Code == clientcode && i.ServiceTypeItem.Code == servicetypecode orderby i.Name ascending select i).FirstOrDefault();
// return item;
//}
public static ServiceCrmEvolutionItem Get(entitiesEvolveCentral ctx, int id)
{
var item = new ServiceCrmEvolutionItem();
item = (from i in ctx.ServiceCrmEvolutionItems where i.Id == id orderby i.Name ascending select i).FirstOrDefault();
return(item);
}
public static bool Delete(entitiesEvolveCentral ctx, ServiceCrmEvolutionItem item)
{
bool retval = true;
try
{
ctx.ServiceCrmEvolutionItems.Remove(item);
ctx.SaveChanges();
}
catch (Exception ex)
{
ApplicationLog.Log(ctx, "DAL.ServiceCrmEvolution.Delete(entitiesEvolveCentral ctx, ServiceCrmEvolutionItem item)", ex.Message);
retval = false;
}
return(retval);
}
public static bool Save(entitiesEvolveCentral ctx, ServiceCrmEvolutionItem item)
{
try
{
if (item.Id == 0)
{
ctx.ServiceCrmEvolutionItems.Add(item);
}
ctx.SaveChanges();
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public static bool Revert(entitiesEvolveCentral ctx, int id)
{
var item = new ServiceCrmEvolutionItem();
try
{
DAL.ServiceCrmEvolutionItem sitem = Get(ctx, id);
DAL.ServiceTemplateCrmEvolutionItem stitem = DAL.ServiceTemplateCrmEvolution.Get(ctx, Convert.ToInt32(sitem.ServiceTemplateCrmEvolutionId));
DAL.ServiceCrmEvolutionDetail.DeleteByService(ctx, id, false);
DateTime cdate = DateTime.Now;
foreach (DAL.ServiceTemplateCrmEvolutionDetailItem i in stitem.ServiceTemplateCrmEvolutionDetailItems)
{
DAL.ServiceCrmEvolutionDetailItem newitem = new DAL.ServiceCrmEvolutionDetailItem();
newitem.IsActive = i.IsActive;
newitem.Code = i.Code;
newitem.Command = i.Command;
newitem.IsUnique = false;
newitem.CommandType = i.CommandType;
newitem.Description = i.Description;
newitem.DestinationTable = i.DestinationTable;
newitem.Name = i.Name;
newitem.Sequence = i.Sequence;
newitem.ServiceCrmEvolutionId = sitem.Id;
newitem.SourceTable = i.SourceTable;
if (DAL.ServiceCrmEvolutionDetail.GetByServiceAndCode(ctx, Convert.ToInt32(newitem.ServiceCrmEvolutionId), newitem.Code).Count == 0)
{
DAL.ServiceCrmEvolutionDetail.Save(ctx, newitem);
}
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
