static void SendMail(DAL.ServiceCrmEvolutionDetailItem item, Exception ex)
{
try
{
string message = null;
message = "EVOLVE CENTRAL EXCEPTION REPORT";
message += Environment.NewLine;
message += Environment.NewLine;
message += "CLIENT: " + item.ServiceCrmEvolutionItem.CompanyItem.Name;
message += Environment.NewLine;
message += "SERVICE TYPE: " + item.ServiceCrmEvolutionItem.ServiceTemplateCrmEvolutionItem.ServiceTypeItem.Name;
message += Environment.NewLine;
message += "SERVICE: " + item.ServiceCrmEvolutionItem.Name + " ( " + item.ServiceCrmEvolutionItem.Code + " ) ";
message += Environment.NewLine;
message += "SERVICE COMMAND: " + item.Name + " (ID: " + item.Id.ToString() + " ) ";
message += Environment.NewLine;
message += Environment.NewLine;
message += "EXCEPTION:";
message += Environment.NewLine;
message += Environment.NewLine;
message += ex.Message;
SendMail(message);
}
catch
{
}
}
void DeleteItem(int itemid)
{
DAL.ServiceCrmEvolutionDetailItem item = DAL.ServiceCrmEvolutionDetail.Get(ctx, itemid);
bool succeded = DAL.ServiceCrmEvolutionDetail.Delete(ctx, item);
rgvData.Rebind();
}
static void LogSqlCommandException(DAL.ServiceCrmEvolutionDetailItem item, Exception ex, string message)
{
Console.WriteLine(ex.Message);
LogSqlCommandExceptionToDatabase(item, ex, message);
SendMail(item, ex);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (isValid())
{
DAL.ServiceCrmEvolutionDetailItem item = new DAL.ServiceCrmEvolutionDetailItem();
//if (id != null)
// item = DAL.ServiceCrmEvolutionDetail.GetByID(ctx, (Int32)id);
item.IsActive = chkActive.Checked;
item.Name = txtName.Text;
item.Command = txtCommand.Text;
item.ServiceCrmEvolutionId = serviceid;
item.Sequence = Convert.ToInt32(txtSequence.Text);
item.CommandType = txtCommandType.Text;
item.Description = txtDescription.Text;
item.DestinationTable = txtDestinationTable.Text;
item.SourceTable = txtSourceTable.Text;
item.Code = txtCode.Text;
item.IsUnique = chkUnique.Checked;
DAL.ServiceCrmEvolutionDetail.Save(ctx, item);
Response.Redirect("ServiceDetailList.aspx?id=" + serviceid);
}
}
bool Save()
{
if (!IsValid())
{
return(false);
}
DateTime currentdate = DateTime.Now;
var item = new DAL.ServiceCrmEvolutionDetailItem();
item.ServiceCrmEvolutionId = Convert.ToInt32(GetServiceId());
item.Code = txtCode.Text;
item.Name = txtName.Text;
item.Description = txtDescription.Text;
item.Command = txtCommand.Text;
item.CommandType = txtCommandType.Text;
item.DestinationTable = txtDestinationTable.Text;
item.Sequence = Convert.ToInt32(txtSequence.Text);
item.ModifiedOn = DateTime.Now;
item.LastModifiedAdministratorAccountId = Convert.ToInt32(Helper.Current.AdministratorAccoundId());
item.SourceTable = txtSourceTable.Text;
item.IsActive = chkActive.Checked;
item.LastModifiedMemberAccountId = null;
item.ModifiedOn = currentdate;
item.IsUnique = chkUnique.Checked;
bool succeeded = DAL.ServiceCrmEvolutionDetail.Save(ctx, item);
return(succeeded);
}
public static bool DeleteByService(entitiesEvolveCentral ctx, int id, bool deleteUnique)
{
var item = new ServiceCrmEvolutionDetailItem();
try
{
DAL.ServiceCrmEvolutionItem sitem = DAL.ServiceCrmEvolution.Get(ctx, id);
DAL.ServiceTemplateCrmEvolutionItem stitem = DAL.ServiceTemplateCrmEvolution.Get(ctx, Convert.ToInt32(sitem.ServiceTemplateCrmEvolutionId));
List <DAL.ServiceCrmEvolutionDetailItem> detailitems = DAL.ServiceCrmEvolutionDetail.GetByService(ctx, id);
for (int i = 0; i < detailitems.Count; i++)
{
int detailid = detailitems[i].Id;
DAL.ServiceCrmEvolutionDetailItem sditem = ctx.ServiceCrmEvolutionDetailItems.Find(detailid);
if (deleteUnique)
{
ctx.ServiceCrmEvolutionDetailItems.Remove(sditem);
}
else
{
if (!Convert.ToBoolean(sditem.IsUnique))
{
ctx.ServiceCrmEvolutionDetailItems.Remove(sditem);
}
}
}
ctx.SaveChanges();
}
catch (Exception ex)
{
return(false);
}
return(true);
}
static void LogSqlCommandToDatabase(DAL.ServiceCrmEvolutionDetailItem i, string message)
{
DAL.SyncLogCrmEvolutionDetailItem item = new DAL.SyncLogCrmEvolutionDetailItem();
item.SyncLogCrmEvolutionId = CurrentLogId;
item.Name = message;
item.IsSuccessful = true;
item.ExecutedCommand = i.Name;
item.CreateDate = DateTime.Now;
item.ErrorMessage = null;
DAL.SyncLogCrmEvolutionDetail.Save(ctx, item);
}
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);
}
static void LogSqlCommandExceptionToDatabase(DAL.ServiceCrmEvolutionDetailItem i, Exception ex, string message)
{
DAL.SyncLogCrmEvolutionDetailItem item = new DAL.SyncLogCrmEvolutionDetailItem();
item.SyncLogCrmEvolutionId = CurrentLogId;
item.Name = message;
item.IsSuccessful = false;
item.ExecutedCommand = i.Command;
item.CreateDate = DateTime.Now;
item.ErrorMessage = ex.Message;
DAL.SyncLogCrmEvolutionDetail.Save(ctx, item);
DAL.SyncLogCrmEvolutionItem litem = DAL.SyncLogCrmEvolution.Get(ctx, Convert.ToInt32(item.SyncLogCrmEvolutionId));
litem.IsSuccessful = false;
DAL.SyncLogCrmEvolution.Save(ctx, litem);
}
void LoadData()
{
string id = GetId();
DAL.ServiceCrmEvolutionDetailItem item = DAL.ServiceCrmEvolutionDetail.Get(ctx, Convert.ToInt32(id));
if (item != null)
{
txtId.Text = item.Id.ToString();
txtCode.Text = item.Code;
txtName.Text = item.Name;
txtDescription.Text = item.Description;
txtCommand.Text = item.Command;
txtCommandType.Text = item.CommandType;
txtDestinationTable.Text = item.DestinationTable;
txtSequence.Text = item.Sequence.ToString();
txtSourceTable.Text = item.SourceTable;
DAL.AdministratorAccountItem aia = DAL.AdministratorAccount.Get(ctx, Convert.ToInt32(item.LastModifiedAdministratorAccountId));
if (aia != null)
{
txtLastModifiedAministratorAccount.Text = aia.FirstName + " " + aia.LastName + " ( " + aia.Email + " )";
}
DAL.MemberAccountItem mia = DAL.MemberAccount.Get(ctx, Convert.ToInt32(item.LastModifiedMemberAccountId));
if (mia != null)
{
txtLastModifiedAministratorAccount.Text = mia.FirstName + " " + mia.LastName + " ( " + mia.Email + " )";
}
txtLastModifiedOn.Text = Convert.ToDateTime(item.ModifiedOn).ToShortDateString() + " " + Convert.ToDateTime(item.ModifiedOn).ToShortTimeString();
txtActive.Text = (item.IsActive) ? "Yes" : "No";
if (item.IsUnique.HasValue)
{
txtUnique.Text = (Convert.ToBoolean(item.IsUnique)) ? "Yes" : "No";
}
}
}
void LoadData()
{
string id = (Request.QueryString["id"] != null && !string.IsNullOrEmpty(Request.QueryString["id"])) ? Request.QueryString["id"].ToString() : null;
DAL.ServiceCrmEvolutionDetailItem item = DAL.ServiceCrmEvolutionDetail.Get(ctx, Convert.ToInt32(id));
if (item != null)
{
txtId.Text = item.Id.ToString();
txtCode.Text = item.Code;
txtName.Text = item.Name;
txtDescription.Text = item.Description;
txtCommand.Text = item.Command;
txtCommandType.Text = item.CommandType;
txtDestinationTable.Text = item.DestinationTable;
txtSequence.Text = item.Sequence.ToString();
txtSourceTable.Text = item.SourceTable;
chkActive.Checked = item.IsActive;
chkUnique.Checked = Convert.ToBoolean(item.IsUnique);
}
}
static void LogSqlCommand(DAL.ServiceCrmEvolutionDetailItem item, string message)
{
Console.WriteLine(message);
LogSqlCommandToDatabase(item, message);
}
