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);
}