public static bool Save(Template Template, out string Err)
{
Err = "";
try
{
using (var ConX = new MySqlConnection(DBOps.GetConnectionString(Template.Environment)))
{
ConX.Open();
if (string.IsNullOrWhiteSpace(Template.Environment))
{
if (Template.TemplateID <= 0)
{
return(Template.Create(out Err, ConX));
}
else
{
return(Template.Update(out Err, ConX));
}
}
else
{
return(Template.CopySave(out Err, ConX));
}
}
}
catch (Exception ex)
{
Err = ex.Message;
return(false);
}
}
public bool Save(out string Err)
{
Err = "";
try
{
using (var ConX = new MySqlConnection(DBOps.GetConnectionString(Environment)))
{
ConX.Open();
if (!string.IsNullOrWhiteSpace(Environment))
{
GetIDFromDescription(ConX);
}
if (ID <= 0)
{
return(Create(out Err, ConX));
}
else
{
return(Update(out Err, ConX));
}
}
}
catch (Exception ex)
{
Err = ex.Message;
return(false);
}
}
public static bool Save(TSFile File, out string Err, bool ResetOwnerIfNotFound = true)
{
Err = "";
try
{
using (var ConX = new MySqlConnection(DBOps.GetConnectionString(File.Environment)))
{
ConX.Open();
if (!string.IsNullOrWhiteSpace(File.Environment))
{
File.GetIDFromDescription(ConX, true, ResetOwnerIfNotFound);
}
if (File.TeleSoftwareID <= 0)
{
return(File.Create(out Err, ConX));
}
else
{
return(File.Update(out Err, ConX));
}
}
}
catch (Exception ex)
{
Err = ex.Message;
return(false);
}
}
public bool IsPageRangeValid()
{
using (var con = new MySqlConnection(DBOps.GetConnectionString(Environment)))
{
con.Open();
string sql = @"SELECT COUNT(*) AS cnt
FROM `page`
WHERE PageID<>@PageID
AND FromPageFrameNo<@ToPageFrameNo
AND @FromPageFrameNo<ToPageFrameNo;";
var cmd = new MySqlCommand(sql, con);
cmd.Parameters.AddWithValue("FromPageFrameNo", NormalisedFromPageFrameNo);
cmd.Parameters.AddWithValue("ToPageFrameNo", NormalisedToPageFrameNo);
cmd.Parameters.AddWithValue("PageID", PageID);
return(cmd.ExecuteScalarInt32() == 0);
}
}