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 BranchVideosPost([FromBody] BranchVideoInput bvv)
{
string sJSONResponse = "";
DataTable dt_AppType = new DataTable();
string ServerDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);
int a = 0;
string country_Query = "";
PlanOutPut Pout = new PlanOutPut();
try
{
cnn.Open();
country_Query = "insert into BranchVideos(BranchCode,Videoname,VideoUrl,Video,CreatedBy,CreatedOn,IsDeleted,IsActive) values('" + bvv.BranchCode + "','" + bvv.Videoname + "','" + bvv.VideoUrl + "','" + bvv.Video + "','" + bvv.CreatedBy + "','" + ServerDateTime + "',0,1) SELECT @@IDENTITY;";
SqlCommand tm_cmd = new SqlCommand(country_Query, cnn);
a = Convert.ToInt32(tm_cmd.ExecuteScalar());
Pout.status = "Success";
}
catch (Exception ex)
{
Pout.status = "Fail";
}
finally
{
cnn.Close();
}
sJSONResponse = JsonConvert.SerializeObject(Pout);
return(sJSONResponse);
}