public bool InsertNewItem(U_ADM_ITEM_MASTER item) { A_ADM_ITEM_MASTERDAL obj = new A_ADM_ITEM_MASTERDAL(); U_ADM_MEDIA_MASTERDAL objImg = new U_ADM_MEDIA_MASTERDAL(); U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER(); imgData.Media_Id = Guid.NewGuid().ToString(); imgData.Media_Type = "Image"; imgData.Media_File_Location = item.Media_Id_Img; imgData.Media_Source = ""; imgData.Media_Oth_Dtl = ""; imgData.Created_by = item.Created_by; imgData.Updated_by = item.Updated_by; imgData.Created_Date = DateTime.Now; imgData.Updated_Date = DateTime.Now; item.Item_Id = imgData.Media_Id; item.Item_Status = "1"; item.Item_Source = "No Source"; item.Media_Id_Video = " "; item.Created_Date = DateTime.Now; item.Updated_Date = DateTime.Now; if (objImg.InsertU_ADM_MEDIA_MASTER(imgData)) { item.Media_Id_Img = imgData.Media_Id; if (obj.InsertU_ADM_ITEM_MASTER(item)) { return(true); } } return(false); }
public bool UpdateItemMaster(U_ADM_ITEM_MASTER item) { SqlParameter[] aParms = GetParameters(item); SetParameters(aParms, item); using (SqlConnection conn = General.GetConnection()) { bool status = false; using (SqlTransaction trans = conn.BeginTransaction()) { try { SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SQL_UPDATE_U_ADM_ITEM_MASTER, aParms); trans.Commit(); status = true; } catch (System.Exception e) { Console.Write(e); trans.Rollback(); //log.Error(lobjError, e); throw; } } return(status); } }
public U_ADM_ITEM_MASTER SelectItemDetailsDb(string id) { SqlConnection con = null; SqlParameter[] aParms = new SqlParameter[] { new SqlParameter(PARAM_Item_Id, id) }; U_ADM_ITEM_MASTER item = new U_ADM_ITEM_MASTER(); try { con = General.GetConnection(); SqlDataReader reader = SqlHelper.ExecuteReader(con, CommandType.Text, SQL_SELECT_ALL, aParms); while (reader.Read()) { item.Item_Id = reader.GetString(0); item.Item_Name = reader.GetString(1); item.Item_Desc = reader.GetString(2); item.Item_Status = reader.GetString(3); item.Item_Tentative_Cost = reader.GetDecimal(4); item.Item_Source = reader.GetString(5); item.Media_Id_Img = reader.GetString(6); item.Media_Id_Video = reader.GetString(7); item.Created_Date = reader.GetDateTime(8); item.Updated_Date = reader.GetDateTime(9); item.Created_by = reader.GetString(10); item.Updated_by = reader.GetString(11); } reader.Close(); return(item); } catch (Exception e) { Console.Write(e); return(null); } }
private void SetParameters(SqlParameter[] U_ADM_MEDIA_MASTERParms, U_ADM_ITEM_MASTER toObjU_ADM_ITEM_MASTER) { U_ADM_MEDIA_MASTERParms[0].Value = toObjU_ADM_ITEM_MASTER.Item_Id; U_ADM_MEDIA_MASTERParms[1].Value = toObjU_ADM_ITEM_MASTER.Item_Name; U_ADM_MEDIA_MASTERParms[2].Value = toObjU_ADM_ITEM_MASTER.Item_Desc; U_ADM_MEDIA_MASTERParms[3].Value = toObjU_ADM_ITEM_MASTER.Item_Status; U_ADM_MEDIA_MASTERParms[4].Value = toObjU_ADM_ITEM_MASTER.Item_Tentative_Cost; U_ADM_MEDIA_MASTERParms[5].Value = toObjU_ADM_ITEM_MASTER.Item_Source; U_ADM_MEDIA_MASTERParms[6].Value = toObjU_ADM_ITEM_MASTER.Media_Id_Img; U_ADM_MEDIA_MASTERParms[7].Value = toObjU_ADM_ITEM_MASTER.Media_Id_Video; U_ADM_MEDIA_MASTERParms[8].Value = toObjU_ADM_ITEM_MASTER.Created_Date; U_ADM_MEDIA_MASTERParms[9].Value = toObjU_ADM_ITEM_MASTER.Updated_Date; U_ADM_MEDIA_MASTERParms[10].Value = toObjU_ADM_ITEM_MASTER.Created_by; U_ADM_MEDIA_MASTERParms[11].Value = toObjU_ADM_ITEM_MASTER.Updated_by; }
public bool UpdateItem(A_ADM_ITEM_MASTER item) { A_ADM_ITEM_MASTERDAL ItemDAL = new A_ADM_ITEM_MASTERDAL(); U_ADM_ITEM_MASTER OldData = new U_ADM_ITEM_MASTER(); U_ADM_ITEM_MASTER NewData = new U_ADM_ITEM_MASTER(); U_ADM_MEDIA_MASTERDAL ImgDAL = new U_ADM_MEDIA_MASTERDAL(); U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER(); OldData = ItemDAL.SelectItemDetailsDb(item.Item_ID); if (!(item.Item_PicUrl == "/img/default_product.png") && !(string.IsNullOrEmpty(item.Item_PicUrl))) { imgData.Media_Id = Guid.NewGuid().ToString(); imgData.Media_Type = "Image"; imgData.Media_File_Location = item.Item_PicUrl; imgData.Media_Source = ""; imgData.Media_Oth_Dtl = ""; imgData.Created_by = item.Update_By; imgData.Updated_by = item.Update_By; imgData.Created_Date = DateTime.Now; imgData.Updated_Date = DateTime.Now; ImgDAL.InsertU_ADM_MEDIA_MASTER(imgData); NewData.Media_Id_Img = imgData.Media_Id; } else { NewData.Media_Id_Img = OldData.Media_Id_Img; } NewData.Item_Id = item.Item_ID; NewData.Item_Name = string.IsNullOrEmpty(item.Item_Name) ? OldData.Item_Name : item.Item_Name; NewData.Item_Desc = string.IsNullOrEmpty(item.Item_Desc) ? OldData.Item_Desc : item.Item_Desc; NewData.Item_Status = string.IsNullOrEmpty(item.Item_Status) ? OldData.Item_Status : item.Item_Status; NewData.Item_Tentative_Cost = string.IsNullOrEmpty(Convert.ToString(item.Item_Price)) ? OldData.Item_Tentative_Cost : item.Item_Price; NewData.Item_Source = string.IsNullOrEmpty(item.Item_Source) ? OldData.Item_Source : item.Item_Source; NewData.Media_Id_Video = OldData.Media_Id_Video; NewData.Created_by = OldData.Created_by; NewData.Created_Date = OldData.Created_Date; NewData.Updated_by = string.IsNullOrEmpty(item.Update_By) ? OldData.Updated_by : item.Update_By; NewData.Updated_Date = DateTime.Now; if (ItemDAL.UpdateItemMaster(NewData)) { return(true); } return(false); }
public bool InsertU_ADM_ITEM_MASTER(U_ADM_ITEM_MASTER obj) { if (obj != null) { SqlParameter[] lParamArray = GetParameters(obj); SetParameters(lParamArray, obj); SqlConnection con = General.GetConnection(); if (con == null) { //Connection is not created return(false); } //Execute the insertion int i = SqlHelper.ExecuteNonQuery( con, CommandType.Text, SQL_INSERT_U_ADM_ITEM_MASTER, lParamArray); //Dispose the Sql connection con.Dispose(); if (i == 1) { //Done and insert the object to the table return(true); } else { //Fail to execute the insertion return(false); } } else { //No object found to insert return(false); } }
private SqlParameter[] GetParameters(U_ADM_ITEM_MASTER toObjU_ADM_ITEM_MASTER) { SqlParameter[] objParamArray = SqlHelperParameterCache.GetCachedParameterSet(General.SQL_CONN_STRING, SQL_INSERT_U_ADM_ITEM_MASTER); if (objParamArray == null) { objParamArray = new SqlParameter[] { new SqlParameter(PARAM_Item_Id, toObjU_ADM_ITEM_MASTER.Item_Id), new SqlParameter(PARAM_Item_Name, toObjU_ADM_ITEM_MASTER.Item_Name), new SqlParameter(PARAM_Item_Desc, toObjU_ADM_ITEM_MASTER.Item_Desc), new SqlParameter(PARAM_Item_Status, toObjU_ADM_ITEM_MASTER.Item_Status), new SqlParameter(PARAM_Item_Tentative_Cost, toObjU_ADM_ITEM_MASTER.Item_Source), new SqlParameter(PARAM_Item_Source, toObjU_ADM_ITEM_MASTER.Item_Source), new SqlParameter(PARAM_Media_Id_Img, toObjU_ADM_ITEM_MASTER.Media_Id_Img), new SqlParameter(PARAM_Media_Id_Video, toObjU_ADM_ITEM_MASTER.Media_Id_Video), new SqlParameter(PARAM_Created_Date, toObjU_ADM_ITEM_MASTER.Created_Date), new SqlParameter(PARAM_Updated_Date, toObjU_ADM_ITEM_MASTER.Updated_Date), new SqlParameter(PARAM_Created_by, toObjU_ADM_ITEM_MASTER.Created_by), new SqlParameter(PARAM_Updated_by, toObjU_ADM_ITEM_MASTER.Updated_by), }; SqlHelperParameterCache.CacheParameterSet(General.SQL_CONN_STRING, SQL_INSERT_U_ADM_ITEM_MASTER, objParamArray); } return(objParamArray); }