public bool InsertNewCoupon(Coupons Coupon) { A_ADM_Coupon_RefDAL obj = new A_ADM_Coupon_RefDAL(); U_ADM_MEDIA_MASTERDAL objImg = new U_ADM_MEDIA_MASTERDAL(); U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER(); DateTime now = System.DateTime.Now; imgData.Media_Id = Guid.NewGuid().ToString(); imgData.Media_Type = "Image"; imgData.Media_File_Location = Coupon.Coupon_PicUrl; imgData.Media_Source = ""; imgData.Media_Oth_Dtl = ""; imgData.Created_by = Coupon.Create_By; imgData.Updated_by = Coupon.Update_By; imgData.Created_Date = now; imgData.Updated_Date = now; Coupon.Coupon_id = Guid.NewGuid().ToString(); Coupon.Create_Date = now; Coupon.Update_Date = now; if (objImg.InsertU_ADM_MEDIA_MASTER(imgData)) { Coupon.Coupon_PicUrl = imgData.Media_Id; if (obj.InsertCouponDb(Coupon)) { return(true); } } return(false); }
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); }
private void SetParameters(SqlParameter[] U_ADM_MEDIA_MASTERParms, U_ADM_MEDIA_MASTER tobjU_ADM_MEDIA_MASTER) { U_ADM_MEDIA_MASTERParms[0].Value = tobjU_ADM_MEDIA_MASTER.Media_Id; U_ADM_MEDIA_MASTERParms[1].Value = tobjU_ADM_MEDIA_MASTER.Media_Type; U_ADM_MEDIA_MASTERParms[2].Value = tobjU_ADM_MEDIA_MASTER.Media_File_Location; U_ADM_MEDIA_MASTERParms[3].Value = tobjU_ADM_MEDIA_MASTER.Media_Source; U_ADM_MEDIA_MASTERParms[4].Value = tobjU_ADM_MEDIA_MASTER.Media_Oth_Dtl; U_ADM_MEDIA_MASTERParms[5].Value = tobjU_ADM_MEDIA_MASTER.Created_Date; U_ADM_MEDIA_MASTERParms[6].Value = tobjU_ADM_MEDIA_MASTER.Updated_Date; U_ADM_MEDIA_MASTERParms[7].Value = tobjU_ADM_MEDIA_MASTER.Created_by; U_ADM_MEDIA_MASTERParms[8].Value = tobjU_ADM_MEDIA_MASTER.Updated_by; }
public bool InsertSubAdmin(A_ModelGroupsList SubAdmin) { U_USR_MASTERDAL obj = new U_USR_MASTERDAL(); U_USR_LgnDAL obj1 = new U_USR_LgnDAL(); U_ADM_MEDIA_MASTERDAL ImgDAL = new U_ADM_MEDIA_MASTERDAL(); U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER(); DateTime now = System.DateTime.Now; imgData.Media_Id = Guid.NewGuid().ToString(); imgData.Media_Type = "Image"; imgData.Media_File_Location = SubAdmin.MasterData.Media_Id_Img; imgData.Media_Source = " "; imgData.Media_Oth_Dtl = " "; imgData.Created_by = SubAdmin.MasterData.Created_by; imgData.Updated_by = SubAdmin.MasterData.Updated_by; imgData.Created_Date = DateTime.Now; imgData.Updated_Date = DateTime.Now; ImgDAL.InsertU_ADM_MEDIA_MASTER(imgData); SubAdmin.MasterData.Usr_Id = System.Guid.NewGuid().ToString(); SubAdmin.MasterData.Address_Id = 1; SubAdmin.MasterData.Media_Id_Img = imgData.Media_Id; SubAdmin.MasterData.Created_Date = DateTime.Now; SubAdmin.MasterData.Updated_Date = DateTime.Now; SubAdmin.MasterData.Alt_Email_Id = SubAdmin.LoginData.Email_ID; SubAdmin.MasterData.Gender = SubAdmin.MasterData.Gender; SubAdmin.MasterData.About_member = ""; SubAdmin.MasterData.Rating = "1"; SubAdmin.LoginData.Login_Id = System.Guid.NewGuid().ToString(); SubAdmin.LoginData.Usr_Mst_Id = SubAdmin.MasterData.Usr_Id; SubAdmin.LoginData.Updated_Date = DateTime.Now; SubAdmin.LoginData.Last_Login_Date = DateTime.Now; SubAdmin.LoginData.Created_Date = DateTime.Now; SubAdmin.LoginData.Ip_Address = ""; SubAdmin.LoginData.Login_status = 1; SubAdmin.LoginData.Created_by = SubAdmin.MasterData.Created_by; SubAdmin.LoginData.Updated_by = SubAdmin.MasterData.Updated_by; SubAdmin.MasterData.Date_Of_Birth = DateTime.Now; SubAdmin.MasterData.Wed_anniversary = DateTime.Now; if (obj.InsertU_USR_MASTER(SubAdmin.MasterData)) { if (obj1.InsertU_USR_Lgn(SubAdmin.LoginData)) { return(true); } } return(false); }
public bool GetUpdateCoupon(Coupons cou) { A_ADM_Coupon_RefDAL couDAL = new A_ADM_Coupon_RefDAL(); Coupons OldData = new Coupons(); Coupons NewData = new Coupons(); U_ADM_MEDIA_MASTERDAL ImgDAL = new U_ADM_MEDIA_MASTERDAL(); U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER(); OldData = couDAL.GetSingleCouponDetailDb(cou.Coupon_id); if (!(string.IsNullOrEmpty(cou.Coupon_PicUrl))) { imgData.Media_Id = Guid.NewGuid().ToString(); imgData.Media_Type = "Image"; imgData.Media_File_Location = cou.Coupon_PicUrl; imgData.Media_Source = " "; imgData.Media_Oth_Dtl = " "; imgData.Created_by = cou.Create_By; imgData.Updated_by = cou.Update_By; imgData.Created_Date = DateTime.Now; imgData.Updated_Date = DateTime.Now; ImgDAL.InsertU_ADM_MEDIA_MASTER(imgData); NewData.Coupon_PicUrl = imgData.Media_Id; } else { NewData.Coupon_PicUrl = couDAL.GetCouponMediaIdDb(cou.Coupon_id); } NewData.Coupon_id = cou.Coupon_id; NewData.Coupon_Name = string.IsNullOrEmpty(cou.Coupon_Name) ? OldData.Coupon_Name : cou.Coupon_Name; NewData.Coupon_VenderName = string.IsNullOrEmpty(cou.Coupon_VenderName) ? OldData.Coupon_VenderName : cou.Coupon_VenderName; NewData.Coupon_Desc = string.IsNullOrEmpty(cou.Coupon_Desc) ? OldData.Coupon_Desc : cou.Coupon_Desc; NewData.Coupon_Status = string.IsNullOrEmpty(cou.Coupon_Status) ? OldData.Coupon_Status : cou.Coupon_Status; NewData.Coupon_StartDate = cou.Coupon_StartDate; NewData.Coupon_EndDate = cou.Coupon_EndDate; NewData.Create_By = OldData.Create_By; NewData.Update_By = cou.Update_By; NewData.Create_Date = OldData.Create_Date; NewData.Update_Date = DateTime.Now; if (couDAL.UpdateCouponMaster(NewData)) { return(true); } return(false); }
public string UpdateProfile(Profile odetails) { try { string mediaId = string.Empty; var userprofile = GetUserProfile(odetails.Usr_Id); if (!string.IsNullOrEmpty(odetails.Media_Id_Img)) { mediaId = Guid.NewGuid().ToString(); U_ADM_MEDIA_MASTERDAL omediaDAL = new U_ADM_MEDIA_MASTERDAL(); U_ADM_MEDIA_MASTER omaster = new U_ADM_MEDIA_MASTER(); omaster.Media_Id = mediaId; omaster.Media_Oth_Dtl = ""; omaster.Media_Source = ""; omaster.Media_Type = "Image"; omaster.Updated_by = odetails.Usr_Id; omaster.Updated_Date = DateTime.Now; omaster.Created_by = odetails.Usr_Id; omaster.Created_Date = DateTime.Now; omaster.Media_File_Location = odetails.Media_Id_Img; omediaDAL.InsertU_ADM_MEDIA_MASTER(omaster); } U_USR_MASTERDAL ousrDAL = new U_USR_MASTERDAL(); U_USR_MASTER ousr = new U_USR_MASTER(); ousr.Usr_Id = odetails.Usr_Id; ousr.About_member = string.IsNullOrEmpty(odetails.About_member)?userprofile.About_member:odetails.About_member; ousr.First_Name = string.IsNullOrEmpty(odetails.First_Name)?userprofile.First_Name:odetails.First_Name; ousr.Last_Name = string.IsNullOrEmpty(odetails.Last_Name)?userprofile.Last_Name:odetails.Last_Name; ousr.Gender = string.IsNullOrEmpty(odetails.Gender)?userprofile.Gender:odetails.Gender; ousr.Is_married = odetails.Is_married; ousr.Wed_anniversary = string.IsNullOrEmpty(Convert.ToString(odetails.Wed_anniversary))?userprofile.Wed_anniversary:odetails.Wed_anniversary; ousr.Updated_by = odetails.Usr_Id; ousr.Updated_Date = DateTime.Now; ousr.Date_Of_Birth = string.IsNullOrEmpty(Convert.ToString(odetails.Date_Of_Birth))?DateTime.Now:odetails.Date_Of_Birth; ousr.Created_Date = DateTime.Now; ousr.Alt_Email_Id = string.IsNullOrEmpty(odetails.Alt_Email_Id)?userprofile.Alt_Email_Id:odetails.Alt_Email_Id; ousr.Address_Id = string.IsNullOrEmpty(odetails.Address_Id)?userprofile.Address_Id:odetails.Address_Id; ousr.Media_Id_Img = string.IsNullOrEmpty(mediaId)?userprofile.Extn:mediaId; ousrDAL.Update_UserProfile(ousr); return("1"); } catch { return("0"); // 0 indicates unsuccessfull } }
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_MEDIA_MASTER(U_ADM_MEDIA_MASTER tobjU_ADM_MEDIA_MASTER) { if (tobjU_ADM_MEDIA_MASTER != null) { //Get the parameter list needed by the given object SqlParameter[] lParamArray = GetParameters(tobjU_ADM_MEDIA_MASTER); SetParameters(lParamArray, tobjU_ADM_MEDIA_MASTER); //Get the connection 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_MEDIA_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); } }
public int GetUpdateEvent(Event eve) { U_EVNT_MASTERDAL eveDAL = new U_EVNT_MASTERDAL(); U_ADM_MEDIA_MASTERDAL ImgDAL = new U_ADM_MEDIA_MASTERDAL(); U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER(); U_EVNT_MASTER NewEveObj = new U_EVNT_MASTER(); var OldEveObj = eveDAL.GetSingleEventDetailsDb(eve.Event_id); if (!(eve.Event_PicUrl == "/img/default_event.png") && !(string.IsNullOrEmpty(eve.Event_PicUrl))) { imgData.Media_Id = Guid.NewGuid().ToString(); imgData.Media_Type = "Image"; imgData.Media_File_Location = eve.Event_PicUrl; imgData.Media_Source = " "; imgData.Media_Oth_Dtl = " "; imgData.Created_by = eve.Event_Update_by; imgData.Updated_by = eve.Event_Update_by; imgData.Created_Date = DateTime.Now; imgData.Updated_Date = DateTime.Now; ImgDAL.InsertU_ADM_MEDIA_MASTER(imgData); NewEveObj.Media_Id_Img = imgData.Media_Id; } NewEveObj.Event_Id = string.IsNullOrEmpty(eve.Event_id) ? OldEveObj.Event_id : eve.Event_id; NewEveObj.Event_Name = string.IsNullOrEmpty(eve.Event_Name) ? OldEveObj.Event_Name : eve.Event_Name; NewEveObj.Even_Location = string.IsNullOrEmpty(eve.Event_Location) ? OldEveObj.Event_Location : eve.Event_Location; NewEveObj.Event_Desc = string.IsNullOrEmpty(eve.Event_Desc) ? OldEveObj.Event_Desc : eve.Event_Desc; NewEveObj.Event_Status = string.IsNullOrEmpty(eve.Event_Status) ? OldEveObj.Event_Status : eve.Event_Status; NewEveObj.Event_StartDate = eve.Event_StartDate; NewEveObj.Event_EndDate = eve.Event_EndDate; NewEveObj.Created_Date = DateTime.Now; //do nothing NewEveObj.Updated_Date = DateTime.Now; NewEveObj.Updated_by = eve.Event_Update_by; NewEveObj.Media_Id_Img = string.IsNullOrEmpty(eve.Event_PicUrl) ? eveDAL.GetEventMediaIdDb(eve.Event_id) : imgData.Media_Id; return(eveDAL.Update_EventDetailsDb(NewEveObj)); }
private SqlParameter[] GetParameters(U_ADM_MEDIA_MASTER tobjU_ADM_MEDIA_MASTER) { SqlParameter[] objParamArray = SqlHelperParameterCache.GetCachedParameterSet(General.SQL_CONN_STRING, SQL_INSERT_U_ADM_MEDIA_MASTER); if (objParamArray == null) { //Represents a parameter to a System.Data.SqlClient.SqlCommand, //and optionally, its mapping to System.Data.DataSet columns. objParamArray = new SqlParameter[] { new SqlParameter(PARAM_Media_Id, tobjU_ADM_MEDIA_MASTER.Media_Id), new SqlParameter(PARAM_Media_Type, tobjU_ADM_MEDIA_MASTER.Media_Type), new SqlParameter(PARAM_Media_File_Location, tobjU_ADM_MEDIA_MASTER.Media_File_Location), new SqlParameter(PARAM_Media_Source, tobjU_ADM_MEDIA_MASTER.Media_Source), new SqlParameter(PARAM_Media_Oth_Dtl, tobjU_ADM_MEDIA_MASTER.Media_Oth_Dtl), new SqlParameter(PARAM_Created_Date, tobjU_ADM_MEDIA_MASTER.Created_Date), new SqlParameter(PARAM_Updated_Date, tobjU_ADM_MEDIA_MASTER.Updated_Date), new SqlParameter(PARAM_Created_by, tobjU_ADM_MEDIA_MASTER.Created_by), new SqlParameter(PARAM_Updated_by, tobjU_ADM_MEDIA_MASTER.Updated_by), }; SqlHelperParameterCache.CacheParameterSet(General.SQL_CONN_STRING, SQL_INSERT_U_ADM_MEDIA_MASTER, objParamArray); } return(objParamArray); }
public bool GetUpdateSubAdmin(SubAdmin usr) { U_USR_MASTERDAL userDAL = new U_USR_MASTERDAL(); U_USR_LgnDAL logDAL = new U_USR_LgnDAL(); SubAdmin NewData = new SubAdmin(); U_ADM_MEDIA_MASTERDAL ImgDAL = new U_ADM_MEDIA_MASTERDAL(); U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER(); U_USR_MASTER NewData1 = new U_USR_MASTER(); var OldData = userDAL.GetSingleSubAdminDetailsDb(usr.Usr_Id); if (!(string.IsNullOrEmpty(usr.Media_File_Location))) { imgData.Media_Id = Guid.NewGuid().ToString(); imgData.Media_Type = "Image"; imgData.Media_File_Location = usr.Media_File_Location; imgData.Media_Source = " "; imgData.Media_Oth_Dtl = " "; imgData.Created_by = usr.Created_by; imgData.Updated_by = usr.Updated_by; imgData.Created_Date = DateTime.Now; imgData.Updated_Date = DateTime.Now; ImgDAL.InsertU_ADM_MEDIA_MASTER(imgData); NewData.Media_File_Location = imgData.Media_Id; } else { NewData.Media_File_Location = userDAL.GetMemberMediaIdDb(usr.Usr_Id); } NewData.Usr_Id = usr.Usr_Id; NewData.First_Name = string.IsNullOrEmpty(usr.First_Name) ? OldData.First_Name : usr.First_Name; NewData.Last_Name = string.IsNullOrEmpty(usr.Last_Name) ? OldData.Last_Name : usr.Last_Name; NewData.Alt_Email_Id = string.IsNullOrEmpty(usr.Alt_Email_Id) ? OldData.Alt_Email_Id : usr.Alt_Email_Id; NewData.Gender = string.IsNullOrEmpty(usr.Gender) ? OldData.Gender : usr.Gender; NewData.Usr_role_Id = string.IsNullOrEmpty(Convert.ToString(usr.Usr_role_Id)) ? OldData.Usr_role_Id : usr.Usr_role_Id; NewData.Mobile_Number = string.IsNullOrEmpty(usr.Mobile_Number) ? OldData.Mobile_Number : usr.Mobile_Number; NewData.Login_status = string.IsNullOrEmpty(Convert.ToString(usr.Login_status)) ? OldData.Login_status : usr.Login_status; NewData.Created_Date = OldData.Created_Date; NewData.Updated_Date = DateTime.Now; NewData.Created_by = OldData.Created_by; NewData.Updated_by = string.IsNullOrEmpty(usr.Updated_by) ? OldData.Updated_by : usr.Updated_by; NewData1.Usr_Id = NewData.Usr_Id; NewData1.First_Name = NewData.First_Name; NewData1.Last_Name = NewData.Last_Name; NewData1.Gender = NewData.Gender; NewData1.Usr_role_Id = NewData.Usr_role_Id; NewData1.Media_Id_Img = NewData.Media_File_Location; NewData1.Updated_Date = NewData.Updated_Date; NewData1.Updated_by = NewData.Updated_by; NewData1.Date_Of_Birth = DateTime.Now; NewData1.Wed_anniversary = DateTime.Now; NewData1.Created_Date = DateTime.Now; bool status = logDAL.UpdateMobileStatusDb(NewData.Usr_Id, NewData.Mobile_Number, NewData.Login_status, NewData.Updated_Date, NewData.Updated_by); status = userDAL.Update_SubAdminProfileDb(NewData1); return(true); }