//Convert DataTable To object method public materialClass ConvertToOjbect(DataTable dt) { materialClass obj_material = new materialClass(); for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToString(dt.Rows[i]["Materialid"]) != "") { obj_material.Materialid = Convert.ToInt32(dt.Rows[i]["Materialid"]); } else { obj_material.Materialid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Materialname"]) != "") { obj_material.Materialname = Convert.ToString(dt.Rows[i]["Materialname"]); } else { obj_material.Materialname = Convert.ToString(""); } } return(obj_material); }
//Convert DataTable To List method public List <materialClass> ConvertToList(DataTable dt) { List <materialClass> materiallist = new List <materialClass>(); for (int i = 0; i < dt.Rows.Count; i++) { materialClass obj_material = new materialClass(); if (Convert.ToString(dt.Rows[i]["Materialid"]) != "") { obj_material.Materialid = Convert.ToInt32(dt.Rows[i]["Materialid"]); } else { obj_material.Materialid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Materialname"]) != "") { obj_material.Materialname = Convert.ToString(dt.Rows[i]["Materialname"]); } else { obj_material.Materialname = Convert.ToString(""); } materiallist.Add(obj_material); } return(materiallist); }
//create parameter public void createParameter(materialClass obj, DB_con.DBTrans trans) { try { obj_con.clearParameter(); obj_con.addParameter("@Materialname", string.IsNullOrEmpty(Convert.ToString(obj.Materialname)) ? "" : obj.Materialname); obj_con.addParameter("@Materialid", obj.Materialid, trans); } catch (Exception ex) { throw ex; } }
//Select Constructor public materialCtl(Int32 id) { obj_con = new ConnectionCls(); materialClass obj_mat = new materialClass(); using (DataTable dt = selectdatatable(id)) { if (dt.Rows.Count > 0) { obj_mat.Materialid = Convert.ToInt32(dt.Rows[0]["Materialid"]); obj_mat.Materialname = Convert.ToString(dt.Rows[0]["Materialname"]); } } }
//insert data into database public Int32 insert(materialClass obj) { try { obj_con.clearParameter(); createParameter(obj, DBTrans.Insert); obj_con.BeginTransaction(); obj_con.ExecuteNoneQuery("sp_material_insert", CommandType.StoredProcedure); obj_con.CommitTransaction(); return(obj.Materialid = Convert.ToInt32(obj_con.getValue("@Materialid"))); } catch (Exception ex) { obj_con.RollbackTransaction(); throw new Exception("sp_material_insert"); } }
//update edited object public materialClass updateObject(materialClass obj) { try { materialClass oldObj = selectById(obj.Materialid); if (obj.Materialname == null || obj.Materialname.ToString().Trim() == "update") { obj.Materialname = oldObj.Materialname; } return(obj); } catch (Exception ex) { throw new Exception(ex.Message); } }