/// <summary>
/// @author : TrungMT
/// @CreateDate:04/04/2008
/// @Description: Process add Clip in UI
/// </summary>
/// <param name="pClip">Clip</param>
public void AddClipUI(Clip pClip)
{
// Add row to grid
DataRow row = ((DataView)mdgrClip.DataSource).Table.NewRow();
row["Clip_ID"] = pClip.ClipID;
row["CODE"] = pClip.Code;
row["NAME"] = pClip.Name;
row["CUSTOMER_ID"] = pClip.CustomerID;
row["URL"] = pClip.URL;
row["UPLOAD_DATE"] = pClip.UploadDate;
row["LENGTH"] = pClip.Length;
row["DESCRIPTION"] = pClip.Description;
row["TYPE"] = pClip.Type;
row["CUSTOMER_NAME"] = pClip.CustomerName;
row["LOCAL_NAME"] = pClip.LocalName;
row["##STT##"] = mdgrClip.Rows.Count + 1;
((DataView)mdgrClip.DataSource).Table.Rows.Add(row);
// change current row to last row
mdgrClip.CurrentCell = mdgrClip.Rows[mdgrClip.RowCount - 1].Cells[0];
mdgrClip.CurrentRow.Selected = true;
SetButtonStatus();
//GenSTT();
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Create new Clip and return Clip id auto increment
/// </summary>
/// <param name="pClip">Clip</param>
public int Create(Clip pClip)
{
IDbDataParameter[] parameters = {
MakeParameter("@Code", DbType.String, 10),
MakeParameter("@Name", DbType.String, 400),
MakeParameter("@CUSTOMER_ID", DbType.Int32, 4),
MakeParameter("@URL", DbType.String, 1000),
MakeParameter("@UPLOAD_DATE", DbType.DateTime, 18),
MakeParameter("@LENGTH", DbType.String, 8),
MakeParameter("@DESCRIPTION", DbType.String, 400),
MakeParameter("@TYPE", DbType.String, 10),
MakeParameter("@LOCAL_NAME", DbType.String, 1000)
};
parameters[0].Value = pClip.Code;
parameters[1].Value = pClip.Name;
parameters[2].Value = pClip.CustomerID;
parameters[3].Value = pClip.URL;
parameters[4].Value = pClip.AutoSetUploadDate ? (object)DBNull.Value : (object) pClip.UploadDate;
parameters[5].Value = pClip.Length;
parameters[6].Value = pClip.Description;
parameters[7].Value = pClip.Type;
parameters[8].Value = pClip.LocalName;
int rowAffected = 0;
return RunProcedure("sp_ADV_Clip_INSERT", parameters, out rowAffected);
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/04/2008
/// @Description: Constrctor to update selected Clip
/// </summary>
public FrmClipItem(FrmClip frmClip, Clip pClip)
: this()
{
mfrmClip = frmClip;
mClip = pClip;
//mOldClip = System.Clo
mblnUpdate = true;
this.Text = "Cap nhat clip";
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Delete 1 Clip with Clip_id
/// </summary>
/// <param name="pClip">Clip</param>
public int Delete(Clip pClip)
{
IDbDataParameter[] parameters = {
MakeParameter("@Clip_ID", DbType.Int32, 10)
};
parameters[0].Value = pClip.ClipID;
int rowAffected = 0;
RunProcedure("sp_ADV_Clip_DELETE", parameters, out rowAffected);
return rowAffected;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/07/2008
/// @Description: Upload 1 clip
/// </summary>
/// <param name="pClip">Clip</param>
private void UploadOneFile(Clip pClip)
{
try
{
// Clear the url stored to db, just wait until file update okie
String pstrLocalFilePath = pClip.URL;
SetProcessingLabel("Uploading: " + pClip.Code + " - " + pClip.Name + " - " + pstrLocalFilePath);
//pClip.URL = "";
// Get local file infor
FileInfo fileInfo = new FileInfo(pstrLocalFilePath);
// check is file exists
if (!fileInfo.Exists)
throw new Exception("Không tìm thấy file để tải lên server.");
pClip.LocalName = fileInfo.Name;
// If this is upload new one, must have clip_id for name of clip in file server
if (UploadMode == UPLOAD_MODE.UPLOAD_NEW)
{
pClip.ClipID = -1;
pClip.ClipID = bClip.Add(pClip);
// Define type and new server file name
pClip.Type = fileInfo.Extension;
pClip.URL = pClip.ClipID + fileInfo.Extension;
//pClip.AutoSetUploadDate = true;
}
// If this is reupload, must delete old clip then reupload
else if (UploadMode == UPLOAD_MODE.RE_UPLOAD)
{
// Delete old server file name
// ftpConnection.Delete
// Define type and new server file name
pClip.Type = fileInfo.Extension;
pClip.URL = pClip.ClipID + fileInfo.Extension;
//pClip.AutoSetUploadDate = true;
}
bClip.Update(pClip);
// Uploading percentage is 0%
SetProcessingValue(0);
// Get file size init for update, and init total uploaded is 0 bytes
long lFileSize = mftpConnection.InitStreamToUpload(pstrLocalFilePath, pClip.URL);
int intUploaded = 0;
long lTotalUploaded = 0;
// If file size is zero
if (lFileSize <= 0)
{
// Every things is immediate 100%
//mftpConnection.UploadAllContent();
SetProcessingValue(100);
SetProcessingStyle(ProgressBarStyle.Marquee);
}
do
{
// If pause clicked, wait
if (Pause)
continue;
if (Cancel)
return;
// Upload each part of content depend on buffer size
intUploaded = mftpConnection.UploadPartOfContent();
lTotalUploaded += intUploaded;
// Update processing percentage.
if (lFileSize > 0)
SetProcessingValue((int)((lTotalUploaded * 100) / lFileSize));
} while (intUploaded > 0);
}
catch (Exception exp)
{
throw exp;
}
finally
{
// release stream after using
mftpConnection.ReleaseStream();
}
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/07/2008
/// @Description: Set clips arrau to upload
/// </summary>
/// <param name="pClips">Clip[]</param>
public void SetUploadClip(Clip[] pClips)
{
mUploadClips = pClips;
OverallMax = mUploadClips.Length;
OverallMin = 0;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Update 1 Clip with Clip_id
/// </summary>
public int Update(Clip pClip)
{
PrClip Clip = new PrClip(Connection);
int intRowAffected = 0;
try
{
Open();
intRowAffected = Clip.Update(pClip);
if (pClip.AutoSetUploadDate)
pClip.UploadDate = Qtc.Libs.Util.DBUtil.getDBSystemTime(Connection);
Commit();
}
catch (Exception exp)
{
Rollback();
throw exp;
}
finally
{
Close();
}
return intRowAffected;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Retrieves all Clip denpend on param
/// </summary>
public DataSet Retrieves(Clip pClip)
{
PrClip Clip = new PrClip(Connection);
try
{
Open();
return Clip.Search(pClip);
}
catch (Exception exp)
{
throw exp;
}
finally
{
Close();
}
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Delete 1 Clip with Clip_id
/// </summary>
public int Delete(Clip pClip)
{
PrClip Clip = new PrClip(Connection);
int intRowAffected = 0;
try
{
Open();
intRowAffected = Clip.Delete(pClip);
Commit();
}
catch (Exception exp)
{
Rollback();
throw exp;
}
finally
{
Close();
}
return intRowAffected;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: make search param depend on combo box
/// </summary>
private Clip MakeSearchParam()
{
Clip clip = new Clip();
clip.ClipID = -1;
clip.CustomerID = -1;
clip.Code = (mcboSearch.SelectedIndex == 1) ? mtxtSearch.Text.Trim() : null;
clip.Name = (mcboSearch.SelectedIndex == 2) ? mtxtSearch.Text.Trim() : null;
clip.Type = (mcboSearch.SelectedIndex == 3) ? mtxtSearch.Text.Trim() : null;
clip.CustomerCode = (mcboSearch.SelectedIndex == 4) ? mtxtSearch.Text.Trim() : null;
clip.CustomerName = (mcboSearch.SelectedIndex == 5) ? mtxtSearch.Text.Trim() : null;
clip.LocalName = (mcboSearch.SelectedIndex == 6) ? mtxtSearch.Text.Trim() : null;
return clip;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/04/2008
/// @Description: Update new Clip in UI
/// </summary>
/// <param name="pClip">Clip</param>
public void UpdateClipUI(Clip pClip)
{
// Update from data to row in grid
mdgrClip.CurrentRow.Cells["Clip_ID"].Value = pClip.ClipID;
mdgrClip.CurrentRow.Cells["CODE"].Value = pClip.Code;
mdgrClip.CurrentRow.Cells["NAME"].Value = pClip.Name;
mdgrClip.CurrentRow.Cells["CUSTOMER_ID"].Value = pClip.CustomerID;
mdgrClip.CurrentRow.Cells["URL"].Value = pClip.URL;
mdgrClip.CurrentRow.Cells["UPLOAD_DATE"].Value = pClip.UploadDate;
mdgrClip.CurrentRow.Cells["LENGTH"].Value = pClip.Length;
mdgrClip.CurrentRow.Cells["DESCRIPTION"].Value = pClip.Description;
mdgrClip.CurrentRow.Cells["TYPE"].Value = pClip.Type;
mdgrClip.CurrentRow.Cells["CUSTOMER_NAME"].Value = pClip.CustomerName;
mdgrClip.CurrentRow.Cells["LOCAL_NAME"].Value = pClip.LocalName;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/04/2008
/// @Description: Get current Clip from grid
/// </summary>
/// <param name="return">Clip</param>
public Clip GetCurrentClip()
{
// Get current row data into Clip
Clip Clip = new Clip();
Clip.ClipID = ((Int32)mdgrClip.CurrentRow.Cells["Clip_ID"].Value);
Clip.Name = (String)mdgrClip.CurrentRow.Cells["NAME"].Value;
Clip.Code = (String)mdgrClip.CurrentRow.Cells["CODE"].Value;
Clip.CustomerID = (Int32)mdgrClip.CurrentRow.Cells["CUSTOMER_ID"].Value;
Clip.URL = (String)mdgrClip.CurrentRow.Cells["URL"].Value;
Clip.UploadDate = (DateTime)mdgrClip.CurrentRow.Cells["UPLOAD_DATE"].Value;
Clip.Length = (string)mdgrClip.CurrentRow.Cells["LENGTH"].Value;
Clip.Description = (String)mdgrClip.CurrentRow.Cells["DESCRIPTION"].Value;
Clip.Type = (String)mdgrClip.CurrentRow.Cells["TYPE"].Value;
Clip.CustomerName = (String)mdgrClip.CurrentRow.Cells["CUSTOMER_NAME"].Value;
Clip.LocalName = (String)mdgrClip.CurrentRow.Cells["LOCAL_NAME"].Value;
// Return
return Clip;
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/04/2008
/// @Description: Process update data
/// </summary>
private bool UpdateData()
{
// Valid condition for update
if (!ValidUpdate())
return false;
// Ask user is sure about update
if (!MsgBoxVN.ShowConfirm(InternalGlobal.UPDATE_QUESTION_MSG, InternalGlobal.UPDATE_QUESTION_CAPTION))
return false;
try
{
// Update on data
//BClip bClip = new BClip();
//GetClipFromCtrl();
//bClip.Update(mClip);
// Check if user want to reupload clip on file server
bool blnUploadNewFile = false;
if (!txtURL.Text.Equals(mClip.URL))
{
blnUploadNewFile = MsgBoxVN.ShowConfirm("Bạn đã đổi đường dẫn file!\n\r Vậy bạn muốn tải lại file khác lên server?", InternalGlobal.UPDATE_QUESTION_MSG);
if (!blnUploadNewFile)
txtURL.Text = mClip.URL;
}
// Get clip from control
GetClipFromCtrl();
// if upload new file
if (blnUploadNewFile)
{
Clip[] clips = new Clip[1];
FrmUploadClip frmUpload = new FrmUploadClip();
clips[0] = mClip;
frmUpload.UploadMode = FrmUploadClip.UPLOAD_MODE.RE_UPLOAD;
frmUpload.SetUploadClip(clips);
frmUpload.Init();
frmUpload.Start();
frmUpload.ShowDialog();
}
// if no, just update database, url no changed
else
{
BClip bClip = new BClip();
mClip.AutoSetUploadDate = false;
bClip.Update(mClip);
}
// Update some ui
txtURL.Text = mClip.URL;
txtType.Text = mClip.Type;
// Update UI of parent form
mfrmClip.UpdateClipUI(mClip);
if (mClip.AutoSetUploadDate)
dteUploaDate.Value = mClip.UploadDate;
// show success message and close form
StoreItem();
MsgBoxVN.ShowInfor(InternalGlobal.UPDATE_SUCCESS_MSG, InternalGlobal.UPDATE_QUESTION_CAPTION);
Close();
return true;
}
catch (Exception exp)
{
MsgBoxVN.ShowError(exp.Message,Dic.STRING_WARNING);
return false;
}
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/04/2008
/// @Description: Process add data
/// </summary>
private bool Add()
{
// Valid condition for add
if (!ValidAdd())
return false;
try
{
// Add data
//BClip bClip = new BClip();
GetClipFromCtrl();
Clip[] clips = new Clip[1];
FrmUploadClip frmUpload = new FrmUploadClip();
clips[0] = mClip;
frmUpload.UploadMode = FrmUploadClip.UPLOAD_MODE.UPLOAD_NEW;
frmUpload.SetUploadClip(clips);
frmUpload.Init();
frmUpload.Start();
frmUpload.ShowDialog();
if (mClip.ClipID >= 0)
mfrmClip.AddClipUI(mClip);
dteUploaDate.Value = mClip.UploadDate;
// Reinit component
InitComponent();
return true;
}
catch (Exception exp)
{
MsgBoxVN.ShowError(exp.Message,Dic.STRING_WARNING);
return false;
}
}
/// <summary>
/// @author : TrungMT
/// @CreateDate:04/03/2008
/// @Description: Searh all Clip
/// </summary>
public DataSet Search(Clip pClip)
{
IDbDataParameter[] parameters = {
MakeParameter("@Clip_ID", DbType.Int32, 10),
MakeParameter("@CLIP_CODE", DbType.String, 10),
MakeParameter("@CLIP_NAME", DbType.String, 200),
MakeParameter("@CUSTOMER_ID", DbType.Int32, 10),
MakeParameter("@UPLOAD_DATE_TO", DbType.DateTime, 16),
MakeParameter("@UPLOAD_DATE_FROM", DbType.DateTime, 16),
MakeParameter("@DESCRIPTION", DbType.String, 1000),
MakeParameter("@TYPE", DbType.String, 10),
MakeParameter("@CUSTOMER_CODE", DbType.String, 10),
MakeParameter("@CUSTOMER_NAME", DbType.String, 200),
MakeParameter("@LOCAL_NAME", DbType.String, 1000),
};
parameters[0].Value = (pClip.ClipID < 0) ? (object)DBNull.Value : (object)pClip.ClipID;
parameters[1].Value = (pClip.Code == null) ? (object)DBNull.Value : (object)pClip.Code;
parameters[2].Value = (pClip.Name == null) ? (object)DBNull.Value : (object)pClip.Name;
parameters[3].Value = (pClip.CustomerID < 0) ? (object)DBNull.Value : (object)pClip.CustomerID;
parameters[4].Value = DBNull.Value;
parameters[5].Value = DBNull.Value;
parameters[6].Value = (pClip.Description == null) ? (object)DBNull.Value : (object)pClip.Description;
parameters[7].Value = (pClip.Type == null) ? (object)DBNull.Value : (object)pClip.Type;
parameters[8].Value = (pClip.CustomerCode == null) ? (object)DBNull.Value : (object)pClip.CustomerCode;
parameters[9].Value = (pClip.CustomerName == null) ? (object)DBNull.Value : (object)pClip.CustomerName;
parameters[10].Value = (pClip.LocalName == null) ? (object)DBNull.Value : (object)pClip.LocalName;
return RunProcedure("sp_ADV_Clip_SELECT_SEARCH", parameters, "ADV_Clip");
}
