public Int32 Save(SalesTransactionItemAttachmentDetails Details)
{
try
{
string SQL = "CALL procSaveTransactionItemAttachments(@TransactionItemAttachmentsID, @TransactionItemsID, @TransactionID, @OrigFileName, @FileName, @UploadedByName, @LastUpdatedByName, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("TransactionItemAttachmentsID", Details.TransactionItemAttachmentsID);
cmd.Parameters.AddWithValue("TransactionItemsID", Details.TransactionItemsID);
cmd.Parameters.AddWithValue("TransactionID", Details.TransactionID);
cmd.Parameters.AddWithValue("OrigFileName", Details.OrigFileName);
cmd.Parameters.AddWithValue("FileName", Details.FileName);
cmd.Parameters.AddWithValue("UploadedByName", Details.UploadedByName);
cmd.Parameters.AddWithValue("LastUpdatedByName", Details.LastUpdatedByName);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
return(base.ExecuteNonQuery(cmd));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(SalesTransactionItemAttachmentDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(SalesTransactionItemAttachmentDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Insert(SalesTransactionItemAttachmentDetails Details)
{
try
{
Save(Details);
return Int32.Parse(base.getLAST_INSERT_ID(this));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Insert(SalesTransactionItemAttachmentDetails Details)
{
try
{
Save(Details);
return(Int32.Parse(base.getLAST_INSERT_ID(this)));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public System.Data.DataTable ListAsDataTable(SalesTransactionItemAttachmentDetails clsSearchKey = new SalesTransactionItemAttachmentDetails(), string SortField = "TransactionItemAttachmentsID", SortOption SortOrder = SortOption.Ascending)
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT TransactionItemAttachmentsID, TransactionItemsID, TransactionID, " +
"OrigFileName, FileName, Deleted, UploadedByName, DeletedByName, LastUpdatedByName, CreatedOn, LastModified " +
"FROM tblTransactionItemAttachments WHERE Deleted = 0 ";
if (clsSearchKey.TransactionItemAttachmentsID != 0)
{
SQL += "AND TransactionItemAttachmentsID = @TransactionItemAttachmentsID ";
cmd.Parameters.AddWithValue("@TransactionItemAttachmentsID", clsSearchKey.TransactionItemAttachmentsID);
}
if (clsSearchKey.TransactionItemsID != 0)
{
SQL += "AND TransactionItemsID = @TransactionItemsID ";
cmd.Parameters.AddWithValue("@TransactionItemsID", clsSearchKey.TransactionItemsID);
}
if (clsSearchKey.TransactionID != 0)
{
SQL += "AND TransactionID = @TransactionID ";
cmd.Parameters.AddWithValue("@TransactionID", clsSearchKey.TransactionID);
}
SQL += "ORDER BY " + (!string.IsNullOrEmpty(SortField) ? SortField : "TransactionItemAttachmentsID") + " ";
SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC ";
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
return(dt);
}
public SalesTransactionItemAttachmentDetails Details(Int32 TransactionItemAttachmentsID)
{
try
{
SalesTransactionItemAttachmentDetails clsSearchKey = new SalesTransactionItemAttachmentDetails()
{
TransactionItemAttachmentsID = TransactionItemAttachmentsID
};
System.Data.DataTable dt = ListAsDataTable(clsSearchKey);
SalesTransactionItemAttachmentDetails Details = new SalesTransactionItemAttachmentDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.TransactionItemAttachmentsID = Int64.Parse(dr["TransactionItemAttachmentsID"].ToString());
Details.TransactionItemsID = Int64.Parse(dr["TransactionItemsID"].ToString());
Details.TransactionID = Int64.Parse(dr["TransactionID"].ToString());
Details.OrigFileName = dr["OrigFileName"].ToString();
Details.FileName = dr["FileName"].ToString();
Details.Deleted = bool.Parse(dr["Deleted"].ToString());
Details.UploadedByName = dr["UploadedByName"].ToString();
Details.DeletedByName = dr["DeletedByName"].ToString();
Details.LastUpdatedByName = dr["LastUpdatedByName"].ToString();
Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
Details.LastModified = DateTime.Parse(dr["LastModified"].ToString());
}
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(SalesTransactionItemAttachmentDetails Details)
{
try
{
string SQL = "CALL procSaveTransactionItemAttachments(@TransactionItemAttachmentsID, @TransactionItemsID, @TransactionID, @OrigFileName, @FileName, @UploadedByName, @LastUpdatedByName, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("TransactionItemAttachmentsID", Details.TransactionItemAttachmentsID);
cmd.Parameters.AddWithValue("TransactionItemsID", Details.TransactionItemsID);
cmd.Parameters.AddWithValue("TransactionID", Details.TransactionID);
cmd.Parameters.AddWithValue("OrigFileName", Details.OrigFileName);
cmd.Parameters.AddWithValue("FileName", Details.FileName);
cmd.Parameters.AddWithValue("UploadedByName", Details.UploadedByName);
cmd.Parameters.AddWithValue("LastUpdatedByName", Details.LastUpdatedByName);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public System.Data.DataTable ListAsDataTable(SalesTransactionItemAttachmentDetails clsSearchKey = new SalesTransactionItemAttachmentDetails(), string SortField = "TransactionItemAttachmentsID", SortOption SortOrder = SortOption.Ascending)
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT TransactionItemAttachmentsID, TransactionItemsID, TransactionID, " +
"OrigFileName, FileName, Deleted, UploadedByName, DeletedByName, LastUpdatedByName, CreatedOn, LastModified " +
"FROM tblTransactionItemAttachments WHERE Deleted = 0 ";
if (clsSearchKey.TransactionItemAttachmentsID != 0)
{
SQL += "AND TransactionItemAttachmentsID = @TransactionItemAttachmentsID ";
cmd.Parameters.AddWithValue("@TransactionItemAttachmentsID", clsSearchKey.TransactionItemAttachmentsID);
}
if (clsSearchKey.TransactionItemsID != 0)
{
SQL += "AND TransactionItemsID = @TransactionItemsID ";
cmd.Parameters.AddWithValue("@TransactionItemsID", clsSearchKey.TransactionItemsID);
}
if (clsSearchKey.TransactionID != 0)
{
SQL += "AND TransactionID = @TransactionID ";
cmd.Parameters.AddWithValue("@TransactionID", clsSearchKey.TransactionID);
}
SQL += "ORDER BY " + (!string.IsNullOrEmpty(SortField) ? SortField : "TransactionItemAttachmentsID") + " ";
SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC ";
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
return dt;
}
public SalesTransactionItemAttachmentDetails Details(Int32 TransactionItemAttachmentsID)
{
try
{
SalesTransactionItemAttachmentDetails clsSearchKey = new SalesTransactionItemAttachmentDetails()
{ TransactionItemAttachmentsID = TransactionItemAttachmentsID };
System.Data.DataTable dt = ListAsDataTable(clsSearchKey);
SalesTransactionItemAttachmentDetails Details = new SalesTransactionItemAttachmentDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.TransactionItemAttachmentsID = Int64.Parse(dr["TransactionItemAttachmentsID"].ToString());
Details.TransactionItemsID = Int64.Parse(dr["TransactionItemsID"].ToString());
Details.TransactionID = Int64.Parse(dr["TransactionID"].ToString());
Details.OrigFileName = dr["OrigFileName"].ToString();
Details.FileName = dr["FileName"].ToString();
Details.Deleted = bool.Parse(dr["Deleted"].ToString());
Details.UploadedByName = dr["UploadedByName"].ToString();
Details.DeletedByName = dr["DeletedByName"].ToString();
Details.LastUpdatedByName = dr["LastUpdatedByName"].ToString();
Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
Details.LastModified = DateTime.Parse(dr["LastModified"].ToString());
}
return Details;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
