public List <BOL.ticketattachment> Select(BOL.ticketattachment obj) { if (obj != null) { conn = new MySqlConnection(ConnectionString); conn.Open(); trans = conn.BeginTransaction(); DataSet ds = bll_ticketattachment.Select(obj, conn, trans); trans.Commit(); conn.Close(); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { List <BOL.ticketattachment> ticketattachmentes = new List <BOL.ticketattachment>(); foreach (DataRow dr in ds.Tables[0].Rows) { BOL.ticketattachment c = new BOL.ticketattachment(); if (dr["Ticketattachmentid"] != null && Convert.ToInt32(dr["Ticketattachmentid"]) > 0) { c.Ticketattachmentid = Convert.ToInt32(Convert.ToString(dr["Ticketattachmentid"])); } if (dr["Link"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Link"]))) { c.Link = Convert.ToString(dr["Link"]); } if (dr["Ticketid"] != null && Convert.ToInt32(dr["Ticketid"]) > 0) { c.Ticketid = Convert.ToInt32(Convert.ToString(dr["Ticketid"])); } if (ds.Tables[0].Columns.Contains("customermobile") && dr["customermobile"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["customermobile"]))) { c.Customers = new BOL.customers(); c.Customers.Mobile = Convert.ToString(dr["customermobile"]) + "/"; } //if (dr["Createdon"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Createdon"]))) //{ // c.Createdon = Convert.ToDateTime(Convert.ToString(dr["Createdon"])); //} if (dr["Isdeleted"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Isdeleted"]))) { c.Isdeleted = Convert.ToString(dr["Isdeleted"]); } //if (dr["Modifyby"] != null && Convert.ToInt32(dr["Modifyby"]) > 0) //{ // c.Modifiedby = Convert.ToInt32(Convert.ToString(dr["Modifyby"])); //} //if (dr["Modifyon"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Modifyon"]))) //{ // c.Modifiedon = Convert.ToDateTime(Convert.ToString(dr["Modifyon"])); //} ticketattachmentes.Add(c); } return(ticketattachmentes); } return(null); } return(null); }