/// <summary> /// 이모티콘을 저장한다. /// </summary> /// <param name="model"></param> /// <param name="file"></param> /// <returns></returns> public static int InsertEmoticon(EmoticonModel model, HttpPostedFile file) { object description = model.Description != null ? (object)model.Description : DBNull.Value; SqlParameter[] param = { CreateInParam("@String", SqlDbType.VarChar, 50, model.EmoticonString), CreateInParam("@Value", SqlDbType.VarChar, 255, model.EmoticonValue), CreateInParam("@Description", SqlDbType.Text, Int32.MaxValue, description), CreateReturnValue() }; SqlCommand cmd = GetSpCommand("UBE_InsertEmoticon", param); try { RepositoryManager.GetInstance().SaveAs("Emoticon", file); cmd.ExecuteNonQuery(); int seqNo = (int)cmd.Parameters["@ReturnValue"].Value; return(seqNo); } catch (Exception e) { throw new UmcDataException("UBE_InsertEmoticon 프로시져 호출중 에러", e); } finally { ReleaseCommand(cmd); } }
/// <summary> /// �̸�Ƽ���� �����Ѵ�. /// </summary> /// <param name="model"></param> /// <param name="file"></param> /// <returns></returns> public static int InsertEmoticon(EmoticonModel model, HttpPostedFile file) { object description = model.Description != null ? (object)model.Description : DBNull.Value; SqlParameter[] param = { CreateInParam("@String", SqlDbType.VarChar,50, model.EmoticonString), CreateInParam("@Value", SqlDbType.VarChar,255, model.EmoticonValue), CreateInParam("@Description", SqlDbType.Text, Int32.MaxValue, description), CreateReturnValue() }; SqlCommand cmd = GetSpCommand("UBE_InsertEmoticon", param); try { RepositoryManager.GetInstance().SaveAs("Emoticon", file); cmd.ExecuteNonQuery(); int seqNo = (int)cmd.Parameters["@ReturnValue"].Value; return seqNo; } catch(Exception e) { throw new UmcDataException("UBE_InsertEmoticon ���ν��� ȣ���� ����",e); } finally { ReleaseCommand(cmd); } }
public static void UpdateEmoticon(EmoticonModel model, HttpPostedFile file) { object description = model.Description != null ? (object)model.Description : DBNull.Value; SqlParameter[] param = { CreateInParam("@SeqNo", SqlDbType.Int, 4, model.SeqNo), CreateInParam("@String", SqlDbType.VarChar, 50, model.EmoticonString), CreateInParam("@Value", SqlDbType.VarChar, 255, model.EmoticonValue), CreateInParam("@Description", SqlDbType.Text, Int32.MaxValue, description), CreateInParam("@InsertDate", SqlDbType.DateTime, 8, (DateTime)model.InsertDate), CreateOutParam("@OldFileName", SqlDbType.VarChar, 255) }; SqlCommand cmd = GetSpCommand("UBE_UpdateEmoticon", param); cmd.ExecuteNonQuery(); if (file.FileName != string.Empty) { string filename = cmd.Parameters["@OldFileName"].Value.ToString(); string serverPath = RepositoryManager.GetInstance().RepositoryDirectory + "\\Emoticon\\" + filename; if (File.Exists(serverPath)) { File.Delete(serverPath); } RepositoryManager.GetInstance().SaveAs("Emoticon", file); } ReleaseCommand(cmd); }
private static void FillEmoticon(IDataRecord row, EmoticonModel model) { model.EmoticonString = (string)row["String"]; model.EmoticonValue = (string)row["Value"]; model.Description = row["Description"] != DBNull.Value ? (string)row["Description"] : string.Empty; model.InsertDate = row["InsertDate"]; }
private void InsertEmoticon() { EmoticonModel model = new EmoticonModel(); model.EmoticonString = txtString.Text; model.EmoticonValue = System.IO.Path.GetFileName(file1.FileName); model.Description = txtDescription.Text; int seqNo = EmoticonManager.GetInstance().InsertEmoticon(model, file1.PostedFile); if (seqNo == -1) { lblResult.Text = string.Format("{0} 는 이미 존재합니다", model.EmoticonString); txtString.Text = string.Empty; return; } txtString.Text = string.Empty; txtDescription.Text = string.Empty; string img = string.Format("<img src='{0}' alt='' />", "/Upload/Emoticon/" + model.EmoticonValue); lblResult.Text = string.Format("{0} 는 {1} 로 저장되었습니다", model.EmoticonString, img); EmoticonManager.GetInstance().Dispose(); }
/// <summary> /// �̸�Ƽ�� ����Ʈ�� �����´�. /// </summary> /// <returns></returns> public static List<EmoticonModel> GetEmoticonList() { SqlCommand cmd = GetSpCommand("UBE_GetEmoticonList"); SqlDataReader reader = cmd.ExecuteReader( CommandBehavior.CloseConnection ); List<EmoticonModel> bindModel = new List<EmoticonModel>(); while (reader.Read()) { EmoticonModel model = new EmoticonModel( (int)reader["SeqNo"] ); FillEmoticon( reader, model ); bindModel.Add( model ); model = null; } ReleaseCommand(cmd); return bindModel; }
/// <summary> /// �̸�Ƽ���� �����´�. /// </summary> /// <param name="seqNo"></param> /// <returns></returns> public static EmoticonModel GetEmoticonBySeqNo(int seqNo) { SqlParameter[] param = { CreateInParam("@SeqNo", SqlDbType.Int,4, seqNo ) }; SqlCommand cmd = GetSpCommand("UBE_GetEmoticonBySeqNo", param); SqlDataReader reader = cmd.ExecuteReader( CommandBehavior.CloseConnection ); EmoticonModel model = new EmoticonModel(seqNo); if (reader.Read()) { FillEmoticon( reader, model ); } else return null; ReleaseCommand(cmd); return model; }
/// <summary> /// 이모티콘 리스트를 가져온다. /// </summary> /// <returns></returns> public static List <EmoticonModel> GetEmoticonList() { SqlCommand cmd = GetSpCommand("UBE_GetEmoticonList"); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); List <EmoticonModel> bindModel = new List <EmoticonModel>(); while (reader.Read()) { EmoticonModel model = new EmoticonModel((int)reader["SeqNo"]); FillEmoticon(reader, model); bindModel.Add(model); model = null; } ReleaseCommand(cmd); return(bindModel); }
/// <summary> /// 이모티콘을 가져온다. /// </summary> /// <param name="seqNo"></param> /// <returns></returns> public static EmoticonModel GetEmoticonBySeqNo(int seqNo) { SqlParameter[] param = { CreateInParam("@SeqNo", SqlDbType.Int, 4, seqNo) }; SqlCommand cmd = GetSpCommand("UBE_GetEmoticonBySeqNo", param); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); EmoticonModel model = new EmoticonModel(seqNo); if (reader.Read()) { FillEmoticon(reader, model); } else { return(null); } ReleaseCommand(cmd); return(model); }
private static void FillEmoticon( IDataRecord row, EmoticonModel model) { model.EmoticonString = (string)row["String"]; model.EmoticonValue = (string)row["Value"]; model.Description = row["Description"] != DBNull.Value ? (string)row["Description"] : string.Empty; model.InsertDate = row["InsertDate"]; }
public static void UpdateEmoticon(EmoticonModel model, HttpPostedFile file) { object description = model.Description != null ? (object)model.Description : DBNull.Value; SqlParameter[] param = { CreateInParam("@SeqNo", SqlDbType.Int,4, model.SeqNo), CreateInParam("@String", SqlDbType.VarChar,50, model.EmoticonString), CreateInParam("@Value", SqlDbType.VarChar,255, model.EmoticonValue), CreateInParam("@Description", SqlDbType.Text, Int32.MaxValue, description), CreateInParam("@InsertDate", SqlDbType.DateTime,8, (DateTime)model.InsertDate), CreateOutParam("@OldFileName", SqlDbType.VarChar,255) }; SqlCommand cmd = GetSpCommand("UBE_UpdateEmoticon", param); cmd.ExecuteNonQuery(); if ( file.FileName != string.Empty) { string filename = cmd.Parameters["@OldFileName"].Value.ToString(); string serverPath = RepositoryManager.GetInstance().RepositoryDirectory + "\\Emoticon\\" + filename; if (File.Exists(serverPath)) File.Delete(serverPath); RepositoryManager.GetInstance().SaveAs("Emoticon", file); } ReleaseCommand(cmd); }
public void UpdateEmoticon(EmoticonModel model, HttpPostedFile file) { EmoticonAccess.UpdateEmoticon( model, file ); }
private void initParam() { seqNo = GetParamInt(PARAM_SEQNO, -1); if (seqNo > 0) model = EmoticonManager.GetInstance().GetEmoticonBySeqNo(seqNo); }
private void ModifyEmoticon() { EmoticonModel modifyModel = new EmoticonModel( seqNo ); modifyModel.EmoticonString = txtString.Text; modifyModel.EmoticonValue = file1.FileName != string.Empty ? System.IO.Path.GetFileName( file1.FileName ) : model.EmoticonValue; modifyModel.Description = txtDescription.Text; modifyModel.InsertDate = DateTime.Now; EmoticonManager.GetInstance().UpdateEmoticon( modifyModel, file1.PostedFile ); string img = string.Format("<img src='{0}' alt='' />", "/Upload/Emoticon/" + modifyModel.EmoticonValue); lblResult.Text = string.Format("{0} 는 {1} 로 수정되었습니다.", modifyModel.EmoticonString, img); }
/// <summary> /// 이모티콘을 저장한다. /// </summary> /// <param name="model"></param> /// <param name="file"></param> /// <returns></returns> public int InsertEmoticon(EmoticonModel model, HttpPostedFile file) { return(EmoticonAccess.InsertEmoticon(model, file)); }
public void UpdateEmoticon(EmoticonModel model, HttpPostedFile file) { EmoticonAccess.UpdateEmoticon(model, file); }
/// <summary> /// �̸�Ƽ���� �����Ѵ�. /// </summary> /// <param name="model"></param> /// <param name="file"></param> /// <returns></returns> public int InsertEmoticon(EmoticonModel model, HttpPostedFile file) { return EmoticonAccess.InsertEmoticon( model, file ); }