public ReturnType AddConsumerVisit(ConsumerVisit consumervisit)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
var u1 = alading.Consumer.FirstOrDefault(c => c.nick == consumervisit.ConsumerNick);
if (u1 == null)
{
return(ReturnType.NotExisted);
}
else
{
u1.last_visit = consumervisit.VisitTime;
alading.AddToConsumerVisit(consumervisit);
if (alading.SaveChanges() == 2)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.PropertyExisted);
}
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType RemoveConsumerVisit(string consumervisitCode)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*List<ConsumerVisit> list = alading.ConsumerVisit.Where(p => p.ConsumerVisitID == consumervisitID).ToList();*/
List <ConsumerVisit> list = alading.ConsumerVisit.Where(p => p.VisitCode == consumervisitCode).ToList();
if (list.Count == 0)
{
return(ReturnType.NotExisted);
}
else
{
ConsumerVisit sy = list.First();
alading.DeleteObject(sy);
alading.SaveChanges();
return(ReturnType.Success);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType UpdateConsumerVisit(ConsumerVisit consumervisit)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*ConsumerVisit result = alading.ConsumerVisit.Where(p => p.ConsumerVisitID == consumervisit.ConsumerVisitID).FirstOrDefault();*/
ConsumerVisit result = alading.ConsumerVisit.Where(p => p.VisitCode == consumervisit.VisitCode).FirstOrDefault();
if (result == null)
{
return(ReturnType.NotExisted);
}
#region Using Attach() Function Update,Default USE;
alading.Attach(result);
alading.ApplyPropertyChanges("ConsumerVisit", consumervisit);
#endregion
#region Using All Items Replace To Update ,Default UnUse
/*
*
* result.Id = consumervisit.Id;
*
* result.VisitCode = consumervisit.VisitCode;
*
* result.ConsumerNick = consumervisit.ConsumerNick;
*
* result.Type = consumervisit.Type;
*
* result.Subject = consumervisit.Subject;
*
* result.Content = consumervisit.Content;
*
* result.VisitTime = consumervisit.VisitTime;
*
* result.Receiver = consumervisit.Receiver;
*
*/
#endregion
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.OthersError);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType UpdateConsumerVisit(string consumervisitCode, ConsumerVisit consumervisit)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*var result = alading.ConsumerVisit.Where(p => p.ConsumerVisitID == consumervisitID).ToList();*/
var result = alading.ConsumerVisit.Where(p => p.VisitCode == consumervisitCode).ToList();
if (result.Count == 0)
{
return(ReturnType.NotExisted);
}
ConsumerVisit ob = result.First();
ob.Id = consumervisit.Id;
ob.VisitCode = consumervisit.VisitCode;
ob.ConsumerNick = consumervisit.ConsumerNick;
ob.Type = consumervisit.Type;
ob.Subject = consumervisit.Subject;
ob.Content = consumervisit.Content;
ob.VisitTime = consumervisit.VisitTime;
ob.Receiver = consumervisit.Receiver;
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.OthersError);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
public static ReturnType UpdateConsumerVisit(string consumervisitCode, ConsumerVisit consumervisit)
{
return(DataProviderClass.Instance().UpdateConsumerVisit(consumervisitCode, consumervisit));
}
public static ReturnType AddConsumerVisit(ConsumerVisit consumervisit)
{
return(DataProviderClass.Instance().AddConsumerVisit(consumervisit));
}
