public Object GetBranchVideos([FromBody] BranchVideoInput bvv)
{
BranchVideoList bvl = new BranchVideoList();
DataSet SelectedSlots = new DataSet();
string sJSONResponse = "";
DataTable dt_Branch = new DataTable();
List <BranchVideosVideos> BranchImage = new List <BranchVideosVideos>();
try
{
dt_Branch = getdata(string.Format("select SNO,Videoname,Video,VideoUrl from BranchVideos where BranchCode='{0}' ", bvv.BranchCode));
for (int i = 0; i < dt_Branch.Rows.Count; i++)
{
BranchVideosVideos bi = new BranchVideosVideos {
SNO = Convert.ToInt32(dt_Branch.Rows[i]["SNO"].ToString()), Video = dt_Branch.Rows[i]["Video"].ToString(), Videoname = dt_Branch.Rows[i]["Videoname"].ToString(), VideoUrl = dt_Branch.Rows[i]["VideoUrl"].ToString()
};
BranchImage.Add(bi);
}
bvl.status = "success";
bvl.value = BranchImage;
sJSONResponse = JsonConvert.SerializeObject(bvl);
}
catch (Exception ec)
{
bvl.status = "fail";
sJSONResponse = JsonConvert.SerializeObject(bvl);
}
return(sJSONResponse);
}
public Object BranchVideosDelete([FromBody] BranchVideosVideos bvv)
{
string sJSONResponse = "";
SqlCommand command = cnn.CreateCommand();
PlanOutPut Pout = new PlanOutPut();
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 BranchVideos where SNO=" + bvv.SNO + " ";
command.ExecuteNonQuery();
transaction.Commit();
Pout.status = "Success";
}
catch (Exception ex)
{
transaction.Rollback();
}
finally
{
}
}
catch (Exception ec)
{
Pout.status = "Success";
}
sJSONResponse = JsonConvert.SerializeObject(Pout);
return(sJSONResponse);
}
