public ActionResult Delete_Com_AvoidCallingTime(string data)
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
if (asset.Delete)
{
int success = 0;
int error = 0;
try
{
string[] separators = { "@@" };
var listRowID = data.Split(separators, StringSplitOptions.RemoveEmptyEntries);
var data1 = new DC_Telesales_AvoidCallingTimeCompany();
foreach (var item in listRowID)
{
data1.Id = Int32.Parse(item);
dbConn.Delete(data1);
}
success++;
}
catch (Exception ex)
{
return(Json(new { success = false, alert = ex.Message }));
}
return(Json(new { success = true, totalSuccess = success, totalError = error }));
}
else
{
return(Json(new { success = false, alert = "You don't have permission to delete record" }));
}
}
public ActionResult Save_Com_AVoidCallingTime(string AvoidCallTime, string TimeFrameDetail, string listCom,
bool Monday, bool Tueday, bool Wednesday, bool Thusday, bool Friday, bool Saturday, bool Sunday)
{
if (asset.Create)
{
TimeFrameDetail = string.IsNullOrEmpty(TimeFrameDetail) ? "All" : TimeFrameDetail;
if (!string.IsNullOrEmpty(AvoidCallTime))
{
try
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
string[] separators = { ";;" };
var listdata = listCom.Split(separators, StringSplitOptions.RemoveEmptyEntries);
if (listdata.Count() == 0)
{
return(Json(new { success = false, error = "Please input field (*)" }));
}
foreach (var id in listdata)
{
if (TimeFrameDetail == "All")
{
var datadetail = dbConn.Select <DC_DetailAvoidCallingTimeFrame>("HeaderID={0}", AvoidCallTime);
foreach (var item in datadetail)
{
var checkexist = dbConn.Select <DC_Telesales_AvoidCallingTimeCompany>("SELECT * FROM DC_Telesales_AvoidCallingTimeCompany WHERE HeaderID = " + AvoidCallTime + " AND DetailHeaderID = " + item.Id + " AND CompanyID = '" + id + "'");
if (checkexist.Count <= 0)
{
var data = new DC_Telesales_AvoidCallingTimeCompany();
data.CompanyID = id;
data.HeaderID = AvoidCallTime;
data.DetailHeaderID = item.Id.ToString();
data.RowCreatedTime = DateTime.Now;
data.RowCreatedUser = currentUser.UserName;
data.RowLastUpdatedTime = DateTime.Parse("1900-01-01");
data.RowLastUpdatedUser = "";
data.Monday = Monday;
data.Tuesday = Tueday;
data.Wednesday = Wednesday;
data.Thursday = Thusday;
data.Friday = Friday;
data.Saturday = Saturday;
data.Sunday = Sunday;
dbConn.Insert(data);;
}
else
{
return(Json(new { success = false, error = "Avoid Call Time is exists." }));
}
}
}
else
{
var checkexist = dbConn.Select <DC_Telesales_AvoidCallingTimeCompany>("SELECT * FROM DC_Telesales_AvoidCallingTimeCompany WHERE HeaderID = " + AvoidCallTime + " AND DetailHeaderID = " + TimeFrameDetail + " AND CompanyID = '" + id + "'");
if (checkexist.Count <= 0)
{
var data = new DC_Telesales_AvoidCallingTimeCompany();
data.CompanyID = id;
data.HeaderID = AvoidCallTime;
data.DetailHeaderID = TimeFrameDetail;
data.RowCreatedTime = DateTime.Now;
data.RowCreatedUser = currentUser.UserName;
data.RowLastUpdatedTime = DateTime.Parse("1900-01-01");
data.RowLastUpdatedUser = "";
data.Monday = Monday;
data.Tuesday = Tueday;
data.Wednesday = Wednesday;
data.Thursday = Thusday;
data.Friday = Friday;
data.Saturday = Saturday;
data.Sunday = Sunday;
dbConn.Insert(data);
}
else
{
return(Json(new { success = false, error = "Avoid Call Time is exists." }));
}
}
}
return(Json(new { success = true }));
}
}
catch (Exception ex)
{
return(Json(new { success = false, error = ex }));
}
}
else
{
return(Json(new { success = false, error = "Please input field (*)" }));
}
}
else
{
return(Json(new { success = false, error = "You don't have permission to add record" }));
}
}
