public Int32 Insert(BOL.rolerights obj)
{
if (obj != null)
{
try
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
bll_rolerights.Insert(obj, conn, trans);
Int32 rolerightsid = bll_utility.GetMaxId("rolerights", "Rolerightsid", conn, trans);
trans.Commit();
conn.Close();
return(rolerightsid);
}
catch
{
trans.Rollback();
conn.Close();
}
}
return(0);
}
public void Initialize()
{
manager_rolerights = new Manager.rolerights();
utility = new Utility();
bol_rolerights = new BOL.rolerights();
manager_roles = new Manager.roles();
bol_roles = new List <BOL.roles>();
}
public Int32 Save(Int32 ticketstatusid)
{
bol_rolerights = new BOL.rolerights();
manager_rolerights = new Manager.rolerights();
bol_rolerights.Roleid = Convert.ToInt32(ddlRoles.SelectedValue);
bol_rolerights.Ticketstatusid = ticketstatusid;
bol_rolerights.Isdeleted = "F";
bol_rolerights.Createdby = Convert.ToInt32(Session["userid"]);
bol_rolerights.Createdon = DateTime.Parse(System.DateTime.Now.ToString("dd/MMM/yyyy"));
bol_rolerights.Rolerightsid = manager_rolerights.Insert(bol_rolerights);
return(bol_rolerights.Rolerightsid);
}
public Int32 Delete(BOL.rolerights obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
try
{
string qry = @"DELETE FROM `rolerights` WHERE `rolerightsid` = " + obj.Rolerightsid;
dbconnect.ExecuteNonQuery(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Insert(BOL.rolerights obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
try
{
string qry = @"INSERT INTO `rolerights`(`ticketstatusid`, `roleid`, `isdeleted`,`createdby`, `createdon`, `modifyby`, `modifyon`)
VALUES (" + obj.Ticketstatusid + "," + obj.Roleid + ",'F'," + obj.Createdby + ",STR_TO_DATE('" + obj.Createdon + "', '%c/%e/%Y %r')" + ",'F','','')";
dbconnect.GetScalar(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Update(BOL.rolerights obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
try
{
string qry = @"UPDATE `rolerights` SET `ticketstatusid` = " + obj.Ticketstatusid + ",`roleid`=" + obj.Roleid +
",`isdeleted`='" + obj.Isdeleted + "',`createdby`=" + obj.Createdby + ",`createdon`=" + obj.Createdon + ",`modifyby`=" + obj.Modifyby +
",`modifyon` = " + obj.Modifyon + " WHERE `rolerightsid`=" + obj.Rolerightsid;
dbconnect.GetScalar(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Delete(BOL.rolerights obj)
{
if (obj != null)
{
try
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
bll_rolerights.Delete(obj, conn, trans);
trans.Commit();
conn.Close();
return(obj.Rolerightsid);
}
catch
{
trans.Rollback();
conn.Close();
}
}
return(0);
}
public DataSet Select(BOL.rolerights obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
StringBuilder qry = new System.Text.StringBuilder();
qry.Append(@"SELECT `rolerightsid`, `ticketstatusid`, `roleid`, `isdeleted`, `createdby`, `createdon`, `modifyby`,
`modifyon` FROM `rolerights` WHERE ");
if (obj.Rolerightsid > 0)
{
qry.Append("`rolerightsid` = " + obj.Rolerightsid + " AND");
}
if (obj.Ticketstatusid > 0)
{
qry.Append("`ticketstatusid` = " + obj.Ticketstatusid + " AND");
}
if (obj.Roleid > 0)
{
qry.Append("`roleid` = " + obj.Roleid + " AND");
}
qry = qry.Remove(qry.Length - 3, qry.Length);
return(dbconnect.GetDataset(conn, trans, qry.ToString()));
}
return(null);
}
public List <BOL.rolerights> Select(BOL.rolerights obj)
{
if (obj != null)
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
DataSet ds = bll_rolerights.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.rolerights> rolerightses = new List <BOL.rolerights>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
BOL.rolerights c = new BOL.rolerights();
if (dr["Roleid"] != null && Convert.ToInt32(dr["Roleid"]) > 0)
{
c.Roleid = Convert.ToInt32(Convert.ToString(dr["Roleid"]));
}
if (dr["Rolerightsid"] != null && Convert.ToInt32(dr["Rolerightsid"]) > 0)
{
c.Rolerightsid = Convert.ToInt32(Convert.ToString(dr["Rolerightsid"]));
}
if (dr["Ticketstatusid"] != null && Convert.ToInt32(dr["Ticketstatusid"]) > 0)
{
c.Ticketstatusid = Convert.ToInt32(Convert.ToString(dr["Ticketstatusid"]));
}
if (dr["Createdby"] != null && Convert.ToInt32(dr["Createdby"]) > 0)
{
c.Createdby = Convert.ToInt32(Convert.ToString(dr["Createdby"]));
}
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.Modifyby = Convert.ToInt32(Convert.ToString(dr["Modifyby"]));
}
if (dr["Modifyon"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Modifyon"])))
{
c.Modifyon = Convert.ToDateTime(Convert.ToString(dr["Modifyon"]));
}
rolerightses.Add(c);
}
return(rolerightses);
}
return(null);
}
return(null);
}
