public bool updateTestimony(TestimonyViewModel testimony, TestimonyViewModel olddetails) { bool result = false; string cmd = "update " + TestimonyTblName + " set "; if (testimony.Language != null && testimony.Language.Trim() != "") { cmd += "Language='" + testimony.Language + "', "; } if (testimony.filePath != null && testimony.filePath.Trim() != "") { cmd += "filePath='" + testimony.filePath + "', "; } if (testimony.Description != null && testimony.Description.Trim() != "") { cmd += "Description='" + testimony.Description + "', "; } if (testimony.Title != null && testimony.Title.Trim() != "") { cmd += "Title='" + testimony.Title + "', "; } cmd += "FileType='" + testimony.FileType + "', "; cmd += getTestimonyupdatecond(olddetails); result = DBCon.UpdateTbl(cmd); return(result); }
public string getTestimonyupdatecond(TestimonyViewModel testimony) { string res = ""; if (testimony.ID != null && testimony.ID > 0) { res += "Id='" + testimony.ID + "' and "; } if (testimony.Language != null && testimony.Language.Trim() != "") { res += "Language='" + testimony.Language + "' and "; } if (testimony.filePath != null && testimony.filePath.Trim() != "") { res += "filePath='" + testimony.filePath + "', "; } if (testimony.Description != null && testimony.Description.Trim() != "") { res += "Description='" + testimony.Description + "', "; } if (testimony.Title != null && testimony.Title.Trim() != "") { res += "Title='" + testimony.Title + "', "; } res += "FileType='" + testimony.FileType + "', "; int andIndex = res.LastIndexOf("and"); res = res.Substring(0, andIndex); return(res); }
public bool deleteTestimony(TestimonyViewModel testimony) { bool result = false; string cmd = "delete from " + TestimonyTblName + " where"; cmd += getTestimonyupdatecond(testimony); result = DBCon.UpdateTbl(cmd); return(result); }
public bool addTestimony(TestimonyViewModel testimony) { bool res = false; string cmd = "Insert into " + TestimonyTblName + "(filePath,Description,Language,Title,FileType) values('" + testimony.filePath + "','" + testimony.Description + "','" + testimony.Language + "','" + testimony.Title + "','" + testimony.FileType + "','" + "')"; res = DBCon.UpdateTbl(cmd); return(res); }
public List <TestimonyViewModel> getTestimonies() { List <TestimonyViewModel> res = new List <TestimonyViewModel>(); DataTable Testimonytable = new DataTable(); string cmd = "select * from " + TestimonyTblName + ""; Testimonytable = DBCon.GetTbl(cmd); foreach (DataRow dr in Testimonytable.Rows) { TestimonyViewModel obj = initialise(dr); res.Add(obj); } return(res); }
public TestimonyViewModel initialise(DataRow dr) { TestimonyViewModel testimony = new TestimonyViewModel(); if (dr["ID"] != null) { testimony.ID = Convert.ToInt32(dr["ID"]); } else { testimony.ID = -9999; } if (dr["Language"] != null) { testimony.Language = dr["Language"].ToString().Trim();; } else { testimony.Language = ""; } if (dr["filePath"] != null) { testimony.filePath = dr["filePath"].ToString().Trim();; } else { testimony.filePath = ""; } if (dr["Description"] != null) { testimony.Description = dr["Description"].ToString().Trim();; } else { testimony.Description = ""; } if (dr["Title"] != null) { testimony.Title = dr["Title"].ToString().Trim();; } else { testimony.Title = ""; } if (dr["FileType"] != null) { testimony.FileType = (StreamEnums.FileTypes)(dr["FileType"]);; } else { testimony.FileType = StreamEnums.FileTypes.Text; } return(testimony); }