public Boolean saveTraderData(String TRDR_FNAME, String TRDR_LNAME, String TRDR_MOB, String TRDR_EMAIL, String TRDR_TMARK, String TRDR_STATE, String TRDR_DIST, String TRDR_PIN)
{
this.TRDR_FNAME = TRDR_FNAME.Trim();
this.TRDR_LNAME = TRDR_LNAME.Trim();
this.TRDR_MOB = TRDR_MOB.Trim();
this.TRDR_EMAIL = TRDR_EMAIL.Trim();
this.TRDR_TMARK = TRDR_TMARK.Trim();
this.TRDR_STATE = TRDR_STATE;
this.TRDR_DIST = TRDR_DIST;
this.TRDR_PIN = TRDR_PIN.Trim();
String TRDR_ID = "TID" + GenerateUniqueID.RandomString(8);
insertQuery = "insert into " + tableName + " values('" + TRDR_ID + "', '" + TRDR_FNAME + "','" + TRDR_LNAME + "','" + TRDR_MOB + "','" + TRDR_EMAIL + "','" + TRDR_TMARK + "','" + TRDR_STATE + "','" + TRDR_DIST + "','" + TRDR_PIN + "');";
if (!(dataAccessUtility.iscolumnAlreadyPresent(tableName, "TRDR_ID", TRDR_ID)))
{
result = insertData(insertQuery);
}
else
{
MessageBox.Show("SomeThing Went Wrong!! Please try Again");
}
return(result);
}
public void DeSpawnMe()
{
try
{
byte[] buff = Client.Packet.ObjectDeSpawn(UniqueID);
lock (Helpers.Manager.clients)
{
for (int i = 0; i < Helpers.Manager.clients.Count; i++)
{
try
{
if (Spawned(Helpers.Manager.clients[i].Character.Information.UniqueID))
{
Helpers.Manager.clients[i].client.Send(buff);
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
}
Spawn.Clear();
}
catch (Exception ex)
{
Log.Exception(ex);
}
finally
{
GenerateUniqueID.Delete(UniqueID);
Helpers.Manager.HelperObject.Remove(this);
Dispose();
}
}
private void addItemSaveBtn_Click(object sender, EventArgs e)
{
String ITEM_CATEGORY = itemCategorySelected;
String ITEM_NAME = itemNameTxt.Text.ToString();
if (String.IsNullOrEmpty(ITEM_CATEGORY))
{
errorProvider1.SetError(addItemCategorycomboBox, "Select Item Category First !");
return;
}
if (String.IsNullOrEmpty(ITEM_NAME))
{
errorProvider1.SetError(itemNameTxt, "Enter Item Name");
return;
}
DataLoadUtility dataLoadUtility = new DataLoadUtility();
String ITEM_ID = GenerateUniqueID.RandomString(5);
String sqlQuery = "insert into item_details values ('" + ITEM_ID + "','" + ITEM_NAME + "','" + ITEM_CATEGORY + "');";
if (!(dataLoadUtility.insertData(sqlQuery)))
{
MessageBox.Show("Item Not Saved");
}
else
{
MessageBox.Show("Item Saved");
this.Close();
}
}
public async Task <IActionResult> Create([Bind("BookID,PublishedDate,UniqueID,Title,Author,Description,Price,Cost,Reordered,PurchaseCount,CopiesOnHand,LastOrdered")] Book book)
{
if (ModelState.IsValid)
{
//Generate next course number
book.UniqueID = GenerateUniqueID.GetNextUniqueID(_context);
_context.Add(book);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(book));
}
public Boolean saveCustomerData(String CUST_FNAME, String CUST_LNAME, String CUST_MOB, String CUST_EMAIL, String CUST_STATE, String CUST_DISTRICT, String CUST_AREA, String CUST_IMG_LOC)
{
this.CUST_FNAME = CUST_FNAME.Trim();
this.CUST_LNAME = CUST_LNAME.Trim();
this.CUST_MOB = CUST_MOB.Trim();
this.CUST_EMAIL = CUST_EMAIL.Trim();
this.CUST_STATE = CUST_STATE;
this.CUST_DISTRICT = CUST_DISTRICT;
this.CUST_AREA = CUST_AREA;
this.CUST_IMG_LOC = CUST_IMG_LOC;
String CUST_ID = GenerateUniqueID.RandomString(8);
if (!(String.IsNullOrEmpty(CUST_IMG_LOC)))
{
String fileExtension = Path.GetExtension(CUST_IMG_LOC);
this.CUST_IMG_FILENAME = CUST_ID + fileExtension;
if (!(copyUtils.copyImag(CUST_IMG_LOC, CUST_IMG_FILENAME)))
{
return(false);
}
}
else
{
this.CUST_IMG_FILENAME = "";
}
//String CUST_ID = "5L9OSNKD";
insertQuery = "insert into " + tableName + " values('" + CUST_FNAME + "','" + CUST_LNAME + "','" + CUST_MOB + "','" + CUST_EMAIL + "','" + CUST_STATE + "','" + CUST_DISTRICT + "','" + CUST_AREA + "','" + AppConstant.IMG_TRAGET_PATH + "','" + CUST_IMG_FILENAME + "', " + " '" + CUST_ID + "');";
if (!(dataAccessUtility.iscolumnAlreadyPresent(tableName, "CUST_ID", CUST_ID)))
{
result = insertData(insertQuery);
}
else
{
MessageBox.Show("SomeThing Went Wrong!! Please try Again");
}
if (!(dataAccessUtility.iscolumnAlreadyPresent(tableName, "CUST_FNAME", CUST_FNAME, "CUST_LNAME", CUST_LNAME, "CUST_AREA", CUST_AREA)))
{
result = insertData(insertQuery);
}
else
{
MessageBox.Show(CUST_FNAME + " " + CUST_LNAME + " " + CUST_AREA + " Is Already Present");
}
return(result);
}
public async Task <IActionResult> Create([Bind("BookID,PublishedDate,UniqueID,Title,Description,Price,Author,Cost,Reorder,CopiesOnHand,LastOrdered,Active")] Book book, int SelectedGenre)
{
book.UniqueID = GenerateUniqueID.GetNextUniqueID(_context);
book.PublishedDate = System.DateTime.Today;
book.Genre = _context.Genres.Find(SelectedGenre);
if (ModelState.IsValid)
{
_context.Add(book);
await _context.SaveChangesAsync();
_context.Update(book);
return(RedirectToAction(nameof(Index)));
}
return(View(book));
}
public IHttpActionResult CreateFolder(FolderManage folder)
{
FolderManage newFolder = new FolderManage();
string userId = HttpContext.Current.User.Identity.Name;
using (var db = new WebDiskDBEntities())
{
string folderName = folder.FolderName;
string parentId = folder.ParentId;
FolderManage parentFolder = db.FolderManage.Where(x => x.FolderId == parentId).SingleOrDefault();
string serverPath = @"C:\WebDisk";
string parentRealPath = parentFolder.RealPath;
string folderFullpath = Path.Combine(serverPath, "8d7g9s", parentRealPath);
if (!Directory.Exists(folderFullpath))
{
Directory.CreateDirectory(folderFullpath);
}
#region 새로운 폴더 생성
newFolder.FolderId = GenerateUniqueID.FolderID(); //고유 폴더 아이디 생성
newFolder.ParentId = parentId;
newFolder.Type = Enum.GetName(typeof(Manage.Enums.ContentType), Manage.Enums.ContentType.Folder).ToLower();
newFolder.ServerPath = serverPath;
newFolder.RealPath = Path.Combine(parentRealPath, folderName);
newFolder.CreatedDate = DateTime.Now;
newFolder.LastAccessed = DateTime.Now;
newFolder.LastModified = DateTime.Now;
newFolder.FolderName = folderName;
newFolder.Starred = false;
newFolder.Trashed = false;
newFolder.OwnerId = "8d7g9s";
#endregion
db.FolderManage.Add(newFolder);
db.SaveChanges();
}
return(Ok(newFolder));
}
public IHttpActionResult UploadFile()
{
string userId = HttpContext.Current.User.Identity.Name; //Header에 포함되어 있는 정보
using (var db = new WebDiskDBEntities())
{
if (HttpContext.Current.Request.Files.Count > 0) //파일개수가 0이상이면
{
HttpFileCollection files = HttpContext.Current.Request.Files;
#region 일 등록하기
for (int i = 0; i < files.Count; i++)
{
var newFile = new FileManage();
HttpPostedFile file = files[i];
if (file.ContentLength > 0)//업로드한 파일의 크기를 가져옴
{
string folderId = HttpContext.Current.Request.Form["folderId"];
var parentFolder = db.FolderManage.Where(x => x.FolderId == folderId).SingleOrDefault();
string fileName = Path.GetFileName(file.FileName);
string serverPath = @"C:\WebDisk";
string realPath = parentFolder.RealPath;
string fullPath = Path.Combine(serverPath, userId, realPath);
if (!Directory.Exists(fullPath))
{
Directory.CreateDirectory(fullPath);
}
file.SaveAs(Path.Combine(fullPath, fileName));
newFile.FileId = GenerateUniqueID.FileID();//고유 파일 아이디 생성
newFile.FolderId = folderId;
newFile.CreatedDate = DateTime.Now;
newFile.LastModified = DateTime.Now;
newFile.LastAccessed = DateTime.Now;
newFile.Type = Enum.GetName(typeof(Manage.Enums.ContentType), Manage.Enums.ContentType.File).ToLower();
newFile.Starred = false;
newFile.Trashed = false;
newFile.OwnerId = userId;
newFile.FileName = Path.GetFileNameWithoutExtension(file.FileName);
newFile.FileExtension = Path.GetExtension(file.FileName).TrimStart('.'); //확장자 앞에 있는 '.'제거
newFile.FileSize = (file.ContentLength / 1024); //kb단위로 저장
newFile.RealPath = realPath;
newFile.ServerPath = serverPath;
#region 업로드된 파일의 마임 타입을 지정한다.
Manage.Enums.MimeType isMimeType = Manage.Enums.MimeType.Unknown;
switch (newFile.FileExtension.ToLower())
{
case "jpg":
case "jpeg":
case "png":
case "gif":
case "bmp":
isMimeType = Manage.Enums.MimeType.Image;
break;
case "doc":
case "docx":
case "xls":
case "xlsx":
case "pdf":
isMimeType = Manage.Enums.MimeType.Document;
break;
}
newFile.MimeType = (byte)isMimeType;
#endregion
db.FileManage.Add(newFile);
db.SaveChanges();
#region 업로드된 파일의 썸네일 생성하기
string rv_FilePreview = Manage.Utils.CreatePreview.CheckFileMap(Path.Combine(fullPath, fileName), newFile.FileId);
if (rv_FilePreview.Contains("오류"))
{
throw new Exception(rv_FilePreview + " << 오류발생했다!!!!");
//1: 원래 생겨야하는 썸네일 등의 이미지를 '파일 썸네일 생성 오류안내' 이미지로 대체한다.
//2: 여기에 후속 대체 기능을 추가해야 한다.
}
else
{
}
#endregion
}
}
#endregion
}
}
return(Ok());
}
/// <summary>
/// 하위 폴더와 파일까지 복사하는 재귀 메소드
/// 호출자는 CopyFolder
/// </summary>
/// <param name="folderId">해당 폴더의 아이디</param>
/// <param name="targetFolderId">타겟 폴더 아이디</param>
public void CopyFolderRecursive(string folderId, string targetFolderId)
{
using (var db = new WebDiskDBEntities())
{
FolderManage sourceFolder = db.FolderManage.Where(x => x.FolderId == folderId).SingleOrDefault();
FolderManage targetFolder = db.FolderManage.Where(x => x.FolderId == targetFolderId).SingleOrDefault();
if (string.IsNullOrEmpty(targetFolder.OwnerId))
{
targetFolder.OwnerId = sourceFolder.OwnerId;
}
string sourPath = Path.Combine(sourceFolder.ServerPath, sourceFolder.OwnerId, sourceFolder.RealPath);
string tarPath = Path.Combine(targetFolder.ServerPath, targetFolder.OwnerId, targetFolder.RealPath, sourceFolder.FolderName);
if (!Directory.Exists(tarPath))
{
Directory.CreateDirectory(tarPath);
}
FolderManage copiedFolder = new FolderManage()
{
FolderId = GenerateUniqueID.FolderID(),
FolderName = sourceFolder.FolderName,
Type = Enum.GetName(typeof(Manage.Enums.ContentType), Manage.Enums.ContentType.Folder).ToLower(),
CreatedDate = DateTime.Now,
LastModified = DateTime.Now,
LastAccessed = DateTime.Now,
OwnerId = sourceFolder.OwnerId,
ParentId = targetFolder.FolderId,
Starred = false,
Trashed = false,
ServerPath = sourceFolder.ServerPath,
RealPath = Path.Combine(targetFolder.RealPath, sourceFolder.FolderName)
};
db.FolderManage.Add(copiedFolder);
db.SaveChanges();
#region 하위 파일 복사하기
List <FileManage> subFiles = db.FileManage.Where(x => x.FolderId == folderId).ToList();
foreach (var subFile in subFiles)
{
string fileName = subFile.FileName + '.' + subFile.FileExtension;
string filePath = Path.Combine(subFile.ServerPath, subFile.OwnerId, subFile.RealPath, fileName);
string tarFilePath = Path.Combine(tarPath, fileName);
if (!File.Exists(tarFilePath))
{
File.Copy(filePath, tarFilePath);
}
FileManage copiedFile = new FileManage()
{
FileId = GenerateUniqueID.FileID(),
FileName = subFile.FileName,
Type = Enum.GetName(typeof(Manage.Enums.ContentType), Manage.Enums.ContentType.File).ToLower(),
FileExtension = subFile.FileExtension,
FileSize = subFile.FileSize,
CreatedDate = DateTime.Now,
LastModified = DateTime.Now,
LastAccessed = DateTime.Now,
OwnerId = subFile.OwnerId,
Starred = false,
Trashed = false,
FolderId = copiedFolder.FolderId,
RealPath = copiedFolder.RealPath,
ServerPath = subFile.ServerPath
};
db.FileManage.Add(copiedFile);
db.SaveChanges();
}
#endregion
#region 하위 폴더 복사하기
List <FolderManage> subFolders = db.FolderManage.Where(x => x.ParentId == folderId).ToList();
foreach (var subFolder in subFolders)
{
CopyFolderRecursive(subFolder.FolderId, copiedFolder.FolderId);
}
#endregion
}
}
public Boolean saveSellsData(SellsEntryForCustomerVO sellsEntryForCustomerVO)
{
this.sellsEntryForCustomerVO = sellsEntryForCustomerVO;
try
{
con = dataBaseConnection.getMySqlDBConnection();
con.Open();
MySqlCommand myCommand = con.CreateCommand();
// Start a local transaction
myTrans = con.BeginTransaction();
// Must assign both transaction object and connection
// to Command object for a pending local transaction
myCommand.Connection = con;
myCommand.Transaction = myTrans;
String CST_INVC_ID = "INVCID" + GenerateUniqueID.RandomString(8);
String CUST_ID = sellsEntryForCustomerVO.Cust_id;
String INVOICE_DATE = sellsEntryForCustomerVO.Date;
double amount = 0;
// Inserting Data into Cust sells_data table
foreach (SellEntryDetails sellEntryDetails in sellsEntryForCustomerVO.SellEntryDetails)
{
String TOT_AMNT = sellEntryDetails.TotalAmount;
amount = amount + Convert.ToDouble(TOT_AMNT);
String QTY = sellEntryDetails.Quantity;
String RATE = sellEntryDetails.Rate1;
String WT_BOX_TYPE = sellEntryDetails.WT_BOX_TYPE1;
String WT_TXT = sellEntryDetails.WT_TXT1;
String SELL_TXN_ID = sellEntryDetails.sell_txn_id1;
String SELL_DATE = sellEntryDetails.sell_date1;
String ITEM_NAME = sellEntryDetails.SellItemName;
insertQuery1 = "insert into " + table1 + " values('" + CUST_ID + "','" + CST_INVC_ID + "','" + INVOICE_DATE + "','" + TOT_AMNT + "','" + SELL_TXN_ID +
"','" + ITEM_NAME + "','" + QTY + "','" + RATE + "','" + SELL_DATE + "','N','N','" + WT_BOX_TYPE + "','" + WT_TXT + "');";
Console.WriteLine(insertQuery1);
if (!(dataAccessUtility.iscolumnAlreadyPresent(table1, "SELL_TXN_ID", SELL_TXN_ID)))
{
insertData(insertQuery1, con);
Console.WriteLine("Sells Entry For Each Lot :" + SELL_TXN_ID);
}
else
{
MessageBox.Show("Some Thing Wrong !! Please Try Again");
return(false);
}
// Inserting Data into trader_sells_book table
foreach (SellsEntryForTraderVO sellsEntryForTraderVO in sellEntryDetails.SellsEntryForTraderVO)
{
String TRDR_ID = sellsEntryForTraderVO.TRDR_ID1;
String G_ENTRY_ID = sellsEntryForTraderVO.G_ENTRY_ID1;
String STOCK_ID = sellsEntryForTraderVO.STOCK_ID1;
String LOT_ID = sellsEntryForTraderVO.LOT_ID1;
insertQuery2 = "insert into " + table2 + " values('" + TRDR_ID + "','" + G_ENTRY_ID + "','" + STOCK_ID + "','" + LOT_ID + "','" + TOT_AMNT +
"','" + SELL_DATE + "','" + SELL_TXN_ID + "');";
Console.WriteLine("trader_sells_book Query:" + insertQuery2);
insertData(insertQuery2, con);
//Update lot_status
String TOT_BAL = sellEntryDetails.tot_bal1;
String TOT_SOLD = sellEntryDetails.tot_sold1;
String TOT_SOLD_IND;
if (int.Parse(TOT_BAL) == 0)
{
TOT_SOLD_IND = "Y";
}
else
{
TOT_SOLD_IND = "N";
}
updateQuery = "update " + table4 + " set TOT_SOLD='" + TOT_SOLD + "',TOT_BAL='" + TOT_BAL + "',TOT_SOLD_IND='" + TOT_SOLD_IND + "' where LOT_ID='"
+ LOT_ID + "' and G_ENTRY_ID='" + G_ENTRY_ID + "'";
insertData(updateQuery, con);
}
}
//Setting Total Bill Amount
sellsEntryForCustomerVO.TotalAmountToday = amount.ToString();
Console.WriteLine("Total Bill:" + sellsEntryForCustomerVO.TotalAmountToday);
//Save Data into Customer Ledger
String TOT_BILL_AMNT = sellsEntryForCustomerVO.TotalAmountToday;
String BLNC_CLEAR = "N";
insertQuery3 = "insert into " + table3 + " values('" + CST_INVC_ID + "','" + CUST_ID + "','" + INVOICE_DATE + "','" + TOT_BILL_AMNT + "','" + BLNC_CLEAR + "');";
Console.WriteLine("cust_ledger Query:" + insertQuery3);
insertData(insertQuery3, con);
myTrans.Commit();
Console.WriteLine("All records are written to database.");
finalResult = true;
return(finalResult);
}
catch (Exception e)
{
finalResult = false;
try
{
myTrans.Rollback();
return(finalResult);
}
catch (MySqlException ex)
{
if (myTrans.Connection != null)
{
Console.WriteLine("An exception of type " + ex.GetType() +
" was encountered while attempting to roll back the transaction.");
}
}
Console.WriteLine("An exception of type " + e.GetType() + " was encountered while inserting the data.");
Console.WriteLine("Neither record was written to database.");
return(finalResult);
}
finally
{
con.Close();
}
}
private void sellsEntryDataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
isCellClicked = true;
SellEntryDetails sellEntryDetails = null;
SellsEntryForTraderVO sellsEntryForTraderVO = null;
if (String.IsNullOrEmpty(itemSelected) || String.IsNullOrEmpty(customerSelected))
{
MessageBox.Show("Please Select Custmer and Item");
}
else
{
try
{
if (e.RowIndex >= 0)
{
String TRDR_FNAME_TMARK = this.sellsEntryDataGridView.Rows[e.RowIndex].Cells[0].Value.ToString();
String RECV_DATE = this.sellsEntryDataGridView.Rows[e.RowIndex].Cells[1].Value.ToString();
String ITEM_NAME = this.sellsEntryDataGridView.Rows[e.RowIndex].Cells[2].Value.ToString();
String WT_BOX_TYPE = this.sellsEntryDataGridView.Rows[e.RowIndex].Cells[3].Value.ToString();
String WT_TXT = this.sellsEntryDataGridView.Rows[e.RowIndex].Cells[4].Value.ToString();
String TOT_BAL = this.sellsEntryDataGridView.Rows[e.RowIndex].Cells[8].Value.ToString();
String LOT_SERIAL = this.sellsEntryDataGridView.Rows[e.RowIndex].Cells[5].Value.ToString();
String G_ENTRY_ID = this.sellsEntryDataGridView.Rows[e.RowIndex].Cells[9].Value.ToString();
String TOT_SOLD = this.sellsEntryDataGridView.Rows[e.RowIndex].Cells[10].Value.ToString();
String TRDR_ID = this.sellsEntryDataGridView.Rows[e.RowIndex].Cells[12].Value.ToString();
String STOCK_ID = this.sellsEntryDataGridView.Rows[e.RowIndex].Cells[14].Value.ToString();
String LOT_ID = this.sellsEntryDataGridView.Rows[e.RowIndex].Cells[15].Value.ToString();
// Console.Write("TRDR_FNAME_TMARK:" + TRDR_FNAME_TMARK + "\nRECV_DATE:" + RECV_DATE + "\nITEM_NAME:" + ITEM_NAME + "\nWT_BOX_TYPE:" + WT_BOX_TYPE + "\nWT_TXT:" + WT_TXT + "\nTOT_BAL:" + TOT_BAL + "\nG_ENTRY_ID:" + G_ENTRY_ID + "\nTOT_SOLD:" + TOT_SOLD + "\nTRDR_ID:" + TRDR_ID + "\nSTOCK_ID:" + STOCK_ID + "\nLOT_ID:" + LOT_ID + "\nCUST_ID" + CUST_ID + "\ncustomerSelected:" + customerSelected);
//dSellsDetailFrm addSellsDetailFrm = new AddSellsDetailFrm(customerSelected, ITEM_NAME);
//addSellsDetailFrm.Show();
using (var form = new AddSellsDetailFrm(customerSelected, ITEM_NAME, TRDR_FNAME_TMARK, TOT_BAL))
{
var result = form.ShowDialog();
if (result == DialogResult.OK)
{
if (int.Parse(form.quantity1) > int.Parse(TOT_BAL))
{
MessageBox.Show("Quantity Is Greater than Total Balance ");
}
else
{
sellsEntryForTraderVO = new SellsEntryForTraderVO();
sellEntryDetails = new SellEntryDetails();
sellEntryDetails.SellItemName = itemSelected;
int totalSold = int.Parse(TOT_SOLD) + int.Parse(form.quantity1);
int totBal = int.Parse(TOT_BAL) - int.Parse(form.quantity1);
sellEntryDetails.Quantity = form.quantity1;
sellEntryDetails.Rate1 = form.rate1;
sellEntryDetails.TotalAmount = form.totalAmount1;
sellEntryDetails.tot_bal1 = totBal.ToString();
sellEntryDetails.tot_sold1 = totalSold.ToString();
sellEntryDetails.sell_txn_id1 = "TxnSell" + GenerateUniqueID.RandomString(8);
sellEntryDetails.sell_date1 = DateHelper.getSqlString(form.sellDate1);
sellEntryDetails.LOT_ID1 = LOT_ID;
sellEntryDetails.SellItemName = ITEM_NAME;
sellEntryDetails.WT_BOX_TYPE1 = WT_BOX_TYPE;
sellEntryDetails.WT_TXT1 = WT_TXT;
}
//Console.Write("\nTotAmount:" + form.totalAmount1);
}
}
if (sellEntryDetails != null && sellsEntryForTraderVO != null)
{
sellsEntryForTraderVO.G_ENTRY_ID1 = G_ENTRY_ID;
sellsEntryForTraderVO.LOT_ID1 = LOT_ID;
sellsEntryForTraderVO.LOT_SERIAL1 = LOT_SERIAL;
sellsEntryForTraderVO.STOCK_ID1 = STOCK_ID;
sellsEntryForTraderVO.TRDR_FNAME_TMARK1 = TRDR_FNAME_TMARK;
sellsEntryForTraderVO.TRDR_ID1 = TRDR_ID;
sellEntryDetails.SellsEntryForTraderVO.Add(sellsEntryForTraderVO);
sellsEntryForCustomerVO.SellEntryDetails.Add(sellEntryDetails);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
/////////////////////////////////////////////////////////////////////////////////
// Pickup item
/////////////////////////////////////////////////////////////////////////////////
void Player_PickUpItem()
{
try
{
//First check if player allready is picking up an item
if (Character.Action.PickUping)
{
//Get item information that the player has selected.
WorldMgr.Items item = Helpers.GetInformation.GetWorldItem(Character.Action.Target);
//Checks
if (item == null)
{
Character.Action.PickUping = false; return;
}
//If the amount is lower then one
if (item.amount < 1)
{
item.amount = 1;
}
//If not gold model
if (item.Model > 3)
{
//Get our free slots
byte slot = GetFreeSlot();
//If to low
if (slot <= 12)
{
Character.Action.PickUping = false;
client.Send(Packet.MoveItemError());
return;
}
//Else continue stop delete timer because its allready beeing removed.
item.StopDeleteTimer();
//Remove the world item spawn
Helpers.Manager.WorldItem.Remove(item);
//Delete the global id
GenerateUniqueID.Delete(item.UniqueID);
//Move towards the item
Send(Packet.StopMovement(new ObjData.vektor(Character.Information.UniqueID,
(float)Formule.packetx((float)item.x, item.xSec),
(float)Character.Position.z,
(float)Formule.packety((float)(float)item.y, item.ySec),
Character.Position.xSec,
Character.Position.ySec)));
//Send animation packet pickup
Send(Packet.Pickup_Animation(Character.Information.UniqueID, 0));
//Check what item type we have (Etc, or armor / weapon).
int amount = 0;
//Set amount or plusvalue
#region Amount definition
if (ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.BLADE ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.CH_SHIELD ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.EU_SHIELD ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.BOW ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.EU_AXE ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.EU_CROSSBOW ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.EU_DAGGER ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.EU_DARKSTAFF ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.EU_HARP ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.EU_STAFF ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.EU_SWORD ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.EU_TSTAFF ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.EU_TSWORD ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.GLAVIE ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.SPEAR ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.SWORD ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.EARRING ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.RING ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.NECKLACE ||
ObjData.Manager.ItemBase[item.Model].Type == ObjData.item_database.ArmorType.ARMOR ||
ObjData.Manager.ItemBase[item.Model].Type == ObjData.item_database.ArmorType.GARMENT ||
ObjData.Manager.ItemBase[item.Model].Type == ObjData.item_database.ArmorType.GM ||
ObjData.Manager.ItemBase[item.Model].Type == ObjData.item_database.ArmorType.HEAVY ||
ObjData.Manager.ItemBase[item.Model].Type == ObjData.item_database.ArmorType.LIGHT ||
ObjData.Manager.ItemBase[item.Model].Type == ObjData.item_database.ArmorType.PROTECTOR ||
ObjData.Manager.ItemBase[item.Model].Itemtype == ObjData.item_database.ItemType.AVATAR ||
ObjData.Manager.ItemBase[item.Model].Type == ObjData.item_database.ArmorType.ROBE)
{
amount = item.PlusValue;
}
else
{
amount = item.amount;
}
#endregion
//Send item creation packet
client.Send(Packet.CREATEITEM(0, slot, item.Model, (short)amount, (int)ObjData.Manager.ItemBase[item.Model].Defans.Durability, ObjData.Manager.ItemBase[item.Model].ID, item.UniqueID));
//Save to database
AddItem(item.Model, (short)amount, slot, Character.Information.CharacterID, item.Model);
}
//If the item is gold
else
{
//Remove the spawned item
Helpers.Manager.WorldItem.Remove(item);
//Remove global id
GenerateUniqueID.Delete(item.UniqueID);
//Movement packet
Send(Packet.StopMovement(new ObjData.vektor(Character.Information.UniqueID,
(float)Formule.packetx((float)item.x, item.xSec),
(float)Character.Position.z,
(float)Formule.packety((float)(float)item.y, item.ySec),
Character.Position.xSec,
Character.Position.ySec)));
//Send animation packet
Send(Packet.Pickup_Animation(Character.Information.UniqueID, 0));
//Add gold to player information
Character.Information.Gold += item.amount;
//Send visual packet for gold
client.Send(Packet.UpdateGold(Character.Information.Gold));
//Send message packet gold gained
client.Send(Packet.GoldMessagePick(item.amount));
//Save player gold
SaveGold();
}
//Despawn item for us
item.DeSpawnMe();
//Dispose of the item
item.Dispose();
//Set picking to false
Character.Action.PickUping = false;
if (Timer.Pickup != null)
{
Timer.Pickup.Dispose();
}
}
}
catch (Exception ex)
{
Console.WriteLine("Pickup Error {0}", ex);
Log.Exception(ex);
}
}
public Boolean saveGoodsEntryData(String TRDR_ID, String ITEM_NAME, String WT_BOX_TYPE, String WT_TXT, String LOT_1, String LOT_2, String LOT_3, String LOT_4, String LOT_5,
String LOGISTIC_DETAILS, String SHORT_BOX, String QTY_RCVD, String ORIGIN, String VEHICLE_NO, String FARE_RATE, String TOTAL_FARE, String RECV_DATE, String TRDR_FNAME_TMARK, String LOT_NO_SHORT)
{
this.TRDR_ID = TRDR_ID.Trim();
this.ITEM_NAME = ITEM_NAME.Trim();
this.WT_BOX_TYPE = WT_BOX_TYPE.Trim();
this.WT_TXT = WT_TXT.Trim();
this.LOT_1 = LOT_1;
this.LOT_2 = LOT_2;
this.LOT_3 = LOT_3;
this.LOT_4 = LOT_4;
this.LOT_5 = LOT_5;
this.LOGISTIC_DETAILS = LOGISTIC_DETAILS;
this.VEHICLE_NO = VEHICLE_NO;
this.FARE_RATE = FARE_RATE;
this.TOTAL_FARE = TOTAL_FARE;
this.SHORT_BOX = SHORT_BOX;
this.ORIGIN = ORIGIN;
this.RECV_DATE = RECV_DATE;
this.QTY_RCVD = QTY_RCVD;
this.TRDR_FNAME_TMARK = TRDR_FNAME_TMARK;
this.LOT_NO_SHORT = LOT_NO_SHORT;
//Entry of goods_entry details
String G_ENTRY_ID = "GETRYID" + GenerateUniqueID.RandomString(8);
try{
con = dataBaseConnection.getMySqlDBConnection();
con.Open();
MySqlCommand myCommand = con.CreateCommand();
// Start a local transaction
myTrans = con.BeginTransaction();
// Must assign both transaction object and connection
// to Command object for a pending local transaction
myCommand.Connection = con;
myCommand.Transaction = myTrans;
insertQuery = "insert into " + tableName + " values('" + G_ENTRY_ID + "','" + TRDR_ID + "','" + ITEM_NAME + "','" + WT_TXT + "','" + LOT_1
+ "','" + LOT_2 + "','" + LOT_3 + "','" + LOT_4 + "','" + LOT_5 + "','" + LOGISTIC_DETAILS + "','" + VEHICLE_NO + "','" + FARE_RATE + "','"
+ TOTAL_FARE + "','" + QTY_RCVD + "','" + ORIGIN + "','" + RECV_DATE + "','" + SHORT_BOX + "','" + WT_BOX_TYPE + "','" + TRDR_FNAME_TMARK + "','" + LOT_NO_SHORT + "');";
Console.WriteLine("Query:" + insertQuery);
if (!(dataAccessUtility.iscolumnAlreadyPresent(tableName, "G_ENTRY_ID", G_ENTRY_ID)))
{
insertData(insertQuery, con);
Console.WriteLine("Goods Entry Inserted");
}
else
{
throw (new CustomException("Some Thing Wrong !! Please Try Again"));
}
//Entry of stock details for each Lot
String stockTable = "stock_details";
String LOTID_1 = "LOT" + GenerateUniqueID.RandomString(8);
String LOTID_2 = "LOT" + GenerateUniqueID.RandomString(8);
String LOTID_3 = "LOT" + GenerateUniqueID.RandomString(8);
String LOTID_4 = "LOT" + GenerateUniqueID.RandomString(8);
String LOTID_5 = "LOT" + GenerateUniqueID.RandomString(8);
String STOCK_ID = "STOCK" + GenerateUniqueID.RandomString(8);
String[] lotIds = new String[] { LOTID_1, LOTID_2, LOTID_3, LOTID_4, LOTID_5 };
String [] lotBoxes = new String[] { this.LOT_1, this.LOT_2, this.LOT_3, this.LOT_4, this.LOT_5 };
String SHORT_LOT_IND = "N";
if (!(String.IsNullOrEmpty(this.LOT_NO_SHORT)))
{
SHORT_LOT_IND = "Y," + lotIds[int.Parse(this.LOT_NO_SHORT) - 1];
}
insertQuery = "insert into " + stockTable + " values('" + G_ENTRY_ID + "','" + LOTID_1 + "','" + LOTID_2 + "','" + LOTID_3 + "','" + LOTID_4
+ "','" + LOTID_5 + "','" + STOCK_ID + "','" + SHORT_LOT_IND + "');";
if (!(dataAccessUtility.iscolumnAlreadyPresent(stockTable, "STOCK_ID", STOCK_ID)))
{
insertData(insertQuery, con);
Console.WriteLine("StockQuery:" + insertQuery);
}
else
{
MessageBox.Show("Some Thing Wrong !! Please Try Again");
return(false);
}
//Entry of lots details into lot details
String lotDetailsTable = "lot_status";
if (SHORT_LOT_IND.Contains("Y"))
{
int index = int.Parse(this.LOT_NO_SHORT) - 1;
int shortbox = int.Parse(this.SHORT_BOX);
lotBoxes[index] = (int.Parse(lotBoxes[index]) - shortbox).ToString();
}
for (int i = 0; i < lotIds.Length; i++)
{
int lotSerial = 0;
if (String.IsNullOrEmpty(lotBoxes[i]))
{
lotSerial = i + 1;
continue;
}
lotSerial = i + 1;
insertQuery = "insert into " + lotDetailsTable + " values('" + lotIds[i] + "','" + lotBoxes[i] + "','" + G_ENTRY_ID + "','0','" + lotBoxes[i] + "','" + lotSerial + "','N');";
insertData(insertQuery, con);
Console.WriteLine("Lot_details_Query:" + insertQuery);
}
myTrans.Commit();
Console.WriteLine("All records are written to database.");
finalResult = true;
return(finalResult);
}
catch (Exception e)
{
finalResult = false;
try
{
myTrans.Rollback();
return(finalResult);
}
catch (MySqlException ex)
{
if (myTrans.Connection != null)
{
Console.WriteLine("An exception of type " + ex.GetType() +
" was encountered while attempting to roll back the transaction.");
}
}
Console.WriteLine("An exception of type " + e.GetType() + " was encountered while inserting the data.");
Console.WriteLine("Neither record was written to database.");
return(finalResult);
}
finally
{
con.Close();
}
}
