void LoadData()
{
string id = GetId();
DAL.ServiceCrmEvolutionItem item = DAL.ServiceCrmEvolution.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;
txtServiceTemplate.Text = item.ServiceTemplateCrmEvolutionItem.Name.ToString();
txtCompany.Text = item.CompanyItem.Name.ToString();
txtConnectionDatabase.Text = item.Connection_DatabaseName;
txtConnectionPassword.Text = item.Connection_DatabasePassword;
txtConnectionServer.Text = item.Connection_DatabaseServer;
txtConnectionUsername.Text = item.Connection_DatabaseUserName;
txtDestinationDatabase.Text = item.DatabaseName_Destination;
txtSourceDatabase.Text = item.DatabaseName_Source;
txtActive.Text = (item.IsActive) ? "Yes" : "No";
if (item.LastSyncSuccessful.HasValue)
{
txtLastSyncSuccesful.Text = (Convert.ToBoolean(item.LastSyncSuccessful)) ? "Yes" : "No";
}
if (item.LastSyncDate.HasValue)
{
txtLastSyncDate.Text = Convert.ToDateTime(item.LastSyncDate).ToShortDateString() + " " + Convert.ToDateTime(item.LastSyncDate).ToShortTimeString();
}
}
}
bool Save()
{
if (!IsValid())
{
return(false);
}
DateTime currentdate = DateTime.Now;
var item = new DAL.ServiceCrmEvolutionItem();
item.Code = txtCode.Text;
item.Name = txtName.Text;
item.Description = txtDescription.Text;
item.ServiceTemplateCrmEvolutionId = Convert.ToInt32(rcbServiceTemplate.SelectedValue);
item.CompanyId = Convert.ToInt32(rcbCompany.SelectedValue);
item.Connection_DatabaseName = txtConnectionDatabase.Text;
item.Connection_DatabasePassword = txtConnectionPassword.Text;
item.Connection_DatabaseServer = txtConnectionServer.Text;
item.Connection_DatabaseUserName = txtConnectionUsername.Text;
item.DatabaseName_Destination = txtDestinationDatabase.Text;
item.DatabaseName_Source = txtSourceDatabase.Text;
item.IsActive = chkActive.Checked;
bool succeeded = DAL.ServiceCrmEvolution.Save(ctx, item);
return(succeeded);
}
public static bool IsCodeAvailable(entitiesEvolveCentral ctx, string value, int?id)
{
bool retval = true;
try
{
DAL.ServiceCrmEvolutionItem item = (from i in ctx.ServiceCrmEvolutionItems where i.Code.ToUpper() == value.ToUpper() select i).FirstOrDefault();
if (item != null)
{
if (id == null)
{
retval = false;
}
if (id != null && item.Id != id)
{
retval = false;
}
}
}
catch (Exception ex)
{
ApplicationLog.Log(ctx, "DAL.ServiceCrmEvolution.IsCodeAvailable(entitiesEvolveCentral ctx, string value, int? id)", ex.Message);
retval = false;
}
return(retval);;
}
void LoadData()
{
string id = (Request.QueryString["id"] != null && !string.IsNullOrEmpty(Request.QueryString["id"])) ? Request.QueryString["id"].ToString() : null;
DAL.ServiceCrmEvolutionItem item = DAL.ServiceCrmEvolution.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;
rcbServiceTemplate.SelectedValue = item.ServiceTemplateCrmEvolutionId.ToString();
rcbCompany.SelectedValue = item.CompanyId.ToString();
txtConnectionDatabase.Text = item.Connection_DatabaseName;
txtConnectionPassword.Text = item.Connection_DatabasePassword;
txtConnectionServer.Text = item.Connection_DatabaseServer;
txtConnectionUsername.Text = item.Connection_DatabaseUserName;
txtDestinationDatabase.Text = item.DatabaseName_Destination;
txtSourceDatabase.Text = item.DatabaseName_Source;
chkActive.Checked = item.IsActive;
}
}
void DeleteItem(int itemid)
{
DAL.ServiceCrmEvolutionItem item = DAL.ServiceCrmEvolution.Get(ctx, itemid);
bool succeded = DAL.ServiceCrmEvolution.Delete(ctx, item);
rgvData.Rebind();
}
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);
}
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);
}
public static void Start(string servicecode)
{
bool isSuccessful = true;
syncstartdate = DateTime.Now;
if (servicecode == null)
{
string message = "READING SERVICE CODE FROM CONFIGURATION FILE FAILED!";
SendMail(message);
isSuccessful = false;
return;
}
DAL.ServiceCrmEvolutionItem serviceitem = DAL.ServiceCrmEvolution.GetByCode(ctx, servicecode);
if (serviceitem == null)
{
string message = "READING SERVICE ITEM WITH CODE= " + servicecode + "FROM THE DATABASE FAILED!";
LogMessage(message, false);
SendMail(message);
isSuccessful = false;
return;
}
int serviceid = serviceitem.Id;
CurrentServiceId = serviceid;
CreateLogInTheDatabase();
LogMessage("READING SERVICE ITEM FROM THE DATABASE WAS SUCESSFUL! - SERVICE ID: " + serviceid.ToString(), true);
List <DAL.ServiceCrmEvolutionDetailItem> items = new List <DAL.ServiceCrmEvolutionDetailItem>();
LogMessage("READING SQL COMMANDS FROM THE DATABASE...", true);
items = DAL.ServiceCrmEvolutionDetail.GetByService(ctx, Convert.ToInt32(serviceid));
if (items.Count == 0)
{
LogMessage("READING SQL COMMANDS FROM THE DATABASE WAS SUCCESSFUL! NUMBER OF ITEMS: " + items.Count.ToString(), false);
return;
}
LogMessage("READING SQL COMMANDS FROM THE DATABASE WAS SUCCESSFUL! NUMBER OF ITEMS: " + items.Count.ToString(), true);
string connstring = null;
string databasename_source = null;
string databasename_destination = null;
connstring = "Server=[@DATABASESERVER];User Id=[@DATABASEUSERNAME];Password=[@DATABASEPASSWORD];DataBase=[@DATABASENAME];";
connstring = connstring.Replace("[@DATABASESERVER]", serviceitem.Connection_DatabaseServer);
connstring = connstring.Replace("[@DATABASEUSERNAME]", serviceitem.Connection_DatabaseUserName);
connstring = connstring.Replace("[@DATABASEPASSWORD]", serviceitem.Connection_DatabasePassword);
connstring = connstring.Replace("[@DATABASENAME]", serviceitem.Connection_DatabaseName);
LogMessage("CONNECTING TO THE DATABASE...", true);
SqlConnection sqlconn = new SqlConnection(connstring);
try
{
sqlconn.Open();
string message = "CONNECTING TO THE DATABASE WAS SUCCESSFUL!";
LogMessage(message, true);
}
catch (Exception ex)
{
LogException(ex, "CONNECTING TO THE DATABASE FAILED!");
isSuccessful = false;
}
LogMessage("EXECUTION OF SQL COMMANDS IS STARTING...", true);
foreach (DAL.ServiceCrmEvolutionDetailItem item in items)
{
try
{
string sqlcommand = item.Command;
sqlcommand = sqlcommand.Replace("[sourceDataBase]", "[" + serviceitem.DatabaseName_Source + "]");
sqlcommand = sqlcommand.Replace("[destinationDataBase]", "[" + serviceitem.DatabaseName_Destination + "]");
SqlCommand cmd = new SqlCommand();
cmd.Connection = sqlconn;
cmd.CommandType = CommandType.Text;
cmd.CommandTimeout = 0;
if (!string.IsNullOrEmpty(sqlcommand))
{
// LogMessage("EXECUTING SQL COMMAND... - " + item.Name + " ( " + item.Id.ToString() + " )");
cmd.CommandText = sqlcommand;
cmd.ExecuteNonQuery();
LogSqlCommand(item, "EXECUTING SQL COMMAND... - " + item.Name + " ( " + item.Id.ToString() + " ) WAS SUCCESSFUL!");
}
}
catch (Exception ex)
{
LogSqlCommandException(item, ex, "EXECUTING SQL COMMAND... - " + item.Name + " ( " + item.Id.ToString() + " ) HAS FAILED!");
isSuccessful = false;
}
finally
{
if (sqlconn != null)
{
// ((IDisposable)sqlconn).Dispose();
}
}
}
try
{
sqlconn.Close();
}
catch (Exception ex)
{
isSuccessful = false;
}
LogMessage("SYNCHRONIZATION FINISHED!", true);
serviceitem.LastSyncDate = DateTime.Now;
serviceitem.LastSyncSuccessful = Convert.ToBoolean(isSuccessful);
DAL.ServiceCrmEvolution.Save(ctx, serviceitem);
}
