public static bool UpdatePost_UpdateDate(Post_Model P_Model) { SqlCommand CMD = new SqlCommand(); CMD.CommandText = @"Update [dbo].[Post] set update_date =getdate() where id=@id"; CMD.Parameters.AddWithValue("@id", P_Model.ID); int Res = new DB().int_ExecuteNonQuery_Odbc(CMD); return(Res > 0 ? true : false); }
public static int InsertPost(Post_Model P_Model) { SqlCommand CMD = new SqlCommand(); CMD.CommandText = @"DECLARE @vocno [int]; INSERT INTO [dbo].[Post] ( [Category_Id], [User_Id], [Title], [Description], [Update_Date]) VALUES ( @Category_Id , @User_Id , @Title , @Description , getdate() ) ; SELECT @vocno = SCOPE_IDENTITY(); INSERT INTO [dbo].[Post_Details] ([Post_Id], [User_id], [Post_TXT], [Post_TypeID] ) VALUES (@vocno,@User_id,@Post_TXT,@Post_TypeID);SELECT @vocno "; CMD.Parameters.AddWithValue("@Category_Id", P_Model.Category_Id); CMD.Parameters.AddWithValue("@User_Id", P_Model.User_Id); CMD.Parameters.AddWithValue("@Title", P_Model.Title); CMD.Parameters.AddWithValue("@Description", P_Model.Description); CMD.Parameters.AddWithValue("@Post_TXT", P_Model.Details_lst[0].Post_TXT); CMD.Parameters.AddWithValue("@Post_TypeID", (int)Post_Type.Post); int Res = 0; Res = new DB().int_ExecuteScalar(CMD); return(Res); }
public static bool InsertPostDetails(Post_Details_Model PD_Model) { SqlCommand CMD = new SqlCommand(); CMD.CommandText = @"INSERT INTO [dbo].[Post_Details] ([Post_Id], [User_id], [Post_TXT], [Post_TypeID] ) VALUES (@Post_Id,@User_id,@Post_TXT,@Post_TypeID)"; CMD.Parameters.AddWithValue("@Post_Id", PD_Model.Post_Id); CMD.Parameters.AddWithValue("@User_id", PD_Model.User_Id); CMD.Parameters.AddWithValue("@Post_TXT", PD_Model.Post_TXT); CMD.Parameters.AddWithValue("@Post_TypeID", (int)PD_Model.Post_TypeID); int Res = new DB().int_ExecuteNonQuery_Odbc(CMD); if (Res > 0) { Post_Model P_ModelOBJ = new Post_Model(); P_ModelOBJ.ID = PD_Model.Post_Id; bool Done = UpdatePost_UpdateDate(P_ModelOBJ); } return(Res > 0 ? true : false); }
private static List <Post_Model> ConvertToPostList(DataTable table) { var postList = new List <Post_Model>(); foreach (DataRow row in table.Rows) { var post = new Post_Model() { ID = (int)row[0], Category_Id = (int)row[1], User_Id = (int)row[2], Title = (string)(row[3] ?? ""), Description = (string)(row[4] == DBNull.Value ? "" : row[4]), Status = (bool)row[5], Date_Created = (DateTime)row[6], Update_Date = row[7] == DBNull.Value ? (DateTime?)null : (DateTime)row[7], Details_lst = GetPostOfDetails((int)row[0]) }; postList.Add(post); } return(postList); }