public Int32 Insert(BOL.roles obj)
{
if (obj != null)
{
try
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
bll_roles.Insert(obj, conn, trans);
Int32 roles = bll_utility.GetMaxId("roles", "Roleid", conn, trans);
trans.Commit();
conn.Close();
return(roles);
}
catch
{
trans.Rollback();
conn.Close();
}
}
return(0);
}
public DataSet SelectAll(BOL.roles obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
StringBuilder qry = new System.Text.StringBuilder();
qry.Append(@"SELECT `roleid`, `rolename`, `description`, `isdeleted`, `createdby`, `createdon`, `modifiedby`, `modifiedon` FROM `roles` ");
return(dbconnect.GetDataset(conn, trans, qry.ToString()));
}
return(null);
}
//public void LoadStatus()
//{
// bol_roles = manager_roles.Select(new BOL.status(), SearchCriterias.all);
// if (bol_roles != null && bol_roles.Count > 0)
// {
// ddlStatus.DataSource = bol_roles;
// ddlStatus.DataTextField = "Statusname";
// ddlStatus.DataValueField = "Statusid";
// ddlStatus.DataBind();
// ddlStatus.Items.Insert(0, new ListItem("--Select--", "-1"));
// }
//}
public Int32 Save()
{
bol_roles = new BOL.roles();
manager_roles = new Manager.roles();
bol_roles.Rolename = txtRoleName.Text;
bol_roles.Description = txtRoleDiscription.Text;
bol_roles.Isdeleted = "F";
bol_roles.Createdby = Convert.ToInt32(Session["userid"]);
bol_roles.Createdon = DateTime.Now;
bol_roles.Modifiedby = Convert.ToInt32(Session["userid"]);
bol_roles.Modifiedon = DateTime.Now;
bol_roles.Roleid = manager_roles.Insert(bol_roles);
return(bol_roles.Roleid);
}
public Int32 Delete(BOL.roles obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
try
{
string qry = @"DELETE FROM `roles` WHERE `roleid`= " + obj.Roleid;
dbconnect.ExecuteNonQuery(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Update(BOL.roles obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
try
{
string qry = @"UPDATE `roles` SET `rolename`='" + obj.Rolename + "',`description`='" + obj.Description +
"',`isdeleted`=' " + obj.Isdeleted + "',`createdby`= " + obj.Createdby + ",`createdon`= " + obj.Createdon + ",`modifiedby`=" + obj.Modifiedby +
",`modifiedon`= " + obj.Modifiedon + " WHERE `roleid`= " + obj.Roleid;
dbconnect.GetScalar(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Insert(BOL.roles obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
try
{
string qry = @"INSERT INTO `roles`(`rolename`, `description`, `isdeleted`, `createdby`, `createdon`, `modifiedby`, `modifiedon`)
VALUES ('" + obj.Rolename + "','" + obj.Description + "','F'," + obj.Createdby + ",STR_TO_DATE('" + obj.Createdon + "', '%c/%e/%Y %r')" + "," + obj.Modifiedby + @",
STR_TO_DATE('" + obj.Modifiedon + "', '%c/%e/%Y %r'))";
dbconnect.GetScalar(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public DataSet Select(BOL.roles obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
StringBuilder qry = new System.Text.StringBuilder();
qry.Append(@"SELECT `roleid`, `rolename`, `description`, `isdeleted`, `createdby`, `createdon`, `modifiedby`, `modifiedon` FROM `roles` WHERE ");
if (obj.Roleid > 0)
{
qry.Append("`roleid` = " + obj.Roleid + " AND");
}
if (!string.IsNullOrEmpty(obj.Rolename))
{
qry.Append("`rolename` = '" + obj.Rolename + "' AND");
}
if (!string.IsNullOrEmpty(obj.Description))
{
qry.Append("`description` = '" + obj.Description + "' AND");
}
qry = qry.Remove(qry.Length - 3, qry.Length);
return(dbconnect.GetDataset(conn, trans, qry.ToString()));
}
return(null);
}
public Int32 Delete(BOL.roles obj)
{
if (obj != null)
{
try
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
bll_roles.Delete(obj, conn, trans);
trans.Commit();
conn.Close();
return(obj.Roleid);
}
catch
{
trans.Rollback();
conn.Close();
}
}
return(0);
}
public List <BOL.roles> Select(BOL.roles obj, SearchCriterias criteria)
{
if (obj != null)
{
DataSet ds = new DataSet();
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
if (criteria.GetHashCode() == SearchCriterias.multiple.GetHashCode())
{
ds = bll_roles.Select(obj, conn, trans);
}
if (criteria.GetHashCode() == SearchCriterias.all.GetHashCode())
{
ds = bll_roles.SelectAll(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.roles> roles = new List <BOL.roles>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
BOL.roles c = new BOL.roles();
if (dr["Roleid"] != DBNull.Value && Convert.ToInt32(dr["Roleid"]) > 0)
{
c.Roleid = Convert.ToInt32(Convert.ToString(dr["Roleid"]));
}
if (dr["Rolename"] != DBNull.Value && !string.IsNullOrEmpty(Convert.ToString(dr["Rolename"])))
{
c.Rolename = Convert.ToString(dr["Rolename"]);
}
if (dr["Description"] != DBNull.Value && !string.IsNullOrEmpty(Convert.ToString(dr["Description"])))
{
c.Description = Convert.ToString(dr["Description"]);
}
if (dr["Createdby"] != DBNull.Value && Convert.ToInt32(dr["Createdby"]) > 0)
{
c.Createdby = Convert.ToInt32(Convert.ToString(dr["Createdby"]));
}
if (dr["Createdon"] != DBNull.Value && !string.IsNullOrEmpty(Convert.ToString(dr["Createdon"])))
{
c.Createdon = Convert.ToDateTime(Convert.ToString(dr["Createdon"]));
}
if (dr["Isdeleted"] != DBNull.Value && !string.IsNullOrEmpty(Convert.ToString(dr["Isdeleted"])))
{
c.Isdeleted = Convert.ToString(dr["Isdeleted"]);
}
if (dr["Modifiedby"] != DBNull.Value && Convert.ToInt32(dr["Modifiedby"]) > 0)
{
c.Modifiedby = Convert.ToInt32(Convert.ToString(dr["Modifiedby"]));
}
if (dr["Modifiedon"] != DBNull.Value && !string.IsNullOrEmpty(Convert.ToString(dr["Modifiedon"])))
{
c.Modifiedon = Convert.ToDateTime(Convert.ToString(dr["Modifiedon"]));
}
roles.Add(c);
}
return(roles);
}
return(null);
}
return(null);
}
public void Initialize()
{
manager_roles = new Manager.roles();
utility = new Utility();
bol_roles = new BOL.roles();
}
