public Object GetDashboardImage([FromBody] DashboardImages da)
{
DashboardImagesOutput daOP = new DashboardImagesOutput();
DataSet SelectedSlots = new DataSet();
string sJSONResponse = "";
DataTable dt_Sessions = new DataTable();
List <DashboardImagesResponse> dalots = new List <DashboardImagesResponse>();
try
{
dt_Sessions = getdata(string.Format("select DI.Id,DI.AppId,DA.ApplicationName,DI.DisplayId,DD.DisplayName,DI.ScreenId,D.ScreenName,DI.ImageURL from DashboardImages DI,Dashboard D,DashboardDisplay DD,DashboardApplications DA where DI.ScreenId=D.ScreenId and DD.ID=DI.DisplayId and DA.ID=DI.AppId and DI.IsActive=1 and DI.IsDeleted=0", ""));
for (int i = 0; i < dt_Sessions.Rows.Count; i++)
{
DashboardImagesResponse SlotsDetails = new DashboardImagesResponse {
id = dt_Sessions.Rows[i]["Id"].ToString(), appId = dt_Sessions.Rows[i]["AppId"].ToString(), applicationName = dt_Sessions.Rows[i]["ApplicationName"].ToString(), displayId = dt_Sessions.Rows[i]["DisplayId"].ToString(), displayName = dt_Sessions.Rows[i]["DisplayName"].ToString(), screenId = dt_Sessions.Rows[i]["ScreenId"].ToString(), screenName = dt_Sessions.Rows[i]["ScreenName"].ToString(), imageURL = dt_Sessions.Rows[i]["ImageURL"].ToString()
};
dalots.Add(SlotsDetails);
}
daOP.status = "success";
daOP.value = dalots;
sJSONResponse = JsonConvert.SerializeObject(daOP);
}
catch (Exception ec)
{
daOP.status = "fail";
sJSONResponse = JsonConvert.SerializeObject(daOP);
}
return(sJSONResponse);
}
public Object DashboardImageUpdate([FromBody] DashboardImages di)
{
SqlCommand command = cnn.CreateCommand();
string ServerDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);
try
{
string b = di.image;
b = b.Substring(b.IndexOf(",") + 1);
string ImageUrl = GetPhotoUrl(b, di.displayId + Convert.ToString(imgname()));
cnn.Close();
cnn.Open();
SqlTransaction transaction;
transaction = cnn.BeginTransaction("SampleTransaction");
command.Connection = cnn;
command.Transaction = transaction;
try
{
command.CommandText = "update DashboardImages set Image='" + b + "',ImageURL='" + ImageUrl + "',ScreenId=" + di.screenId + ",AppId=" + di.appId + ",DisplayId=" + di.displayId + " where Id='" + di.id + "'";
command.ExecuteNonQuery();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
finally
{
}
}
catch (Exception ec)
{
}
string sJSONResponse = "";
return(sJSONResponse);
}
public Object DashboardImage([FromBody] DashboardImages di)
{
string sJSONResponse = "";
DataTable dt_AppType = new DataTable();
string ServerDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);
int a = 0;
string olPackage_Query = "";
PaymentDetailsPost Pdetails = new PaymentDetailsPost();
string b = di.imageUrl;
b = b.Substring(b.IndexOf(",") + 1);
string ImageUrl = GetPhotoUrl(b, di.displayId + Convert.ToString(imgname()));
try
{
cnn.Open();
olPackage_Query = "insert into DashboardImages(AppId,DisplayId,Image,ImageURL,CreatedBy,CreatedOn,IsDeleted,IsActive,ScreenId) values('" + di.appId + "','" + di.displayId + "','" + b + "','" + ImageUrl + "','" + di.createdBy + "','" + ServerDateTime + "',0,1," + di.screenId + ") SELECT @@IDENTITY;";
SqlCommand tm_cmd = new SqlCommand(olPackage_Query, cnn);
a = Convert.ToInt32(tm_cmd.ExecuteScalar());
Pdetails.status = "Success";
Pdetails.transactionId = a;
}
catch (Exception ex)
{
Pdetails.status = "Fail";
}
finally
{
cnn.Close();
}
sJSONResponse = JsonConvert.SerializeObject(Pdetails);
return(sJSONResponse);
}
public Object DashboardImageDelete([FromBody] DashboardImages di)
{
SqlCommand command = cnn.CreateCommand();
string ServerDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);
try
{
cnn.Close();
cnn.Open();
SqlTransaction transaction;
transaction = cnn.BeginTransaction("SampleTransaction");
command.Connection = cnn;
command.Transaction = transaction;
try
{
command.CommandText = "delete from DashboardImages where Id='" + di.id + "' ";
command.ExecuteNonQuery();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
finally
{
}
}
catch (Exception ec)
{
}
string sJSONResponse = "";
return(sJSONResponse);
}