public static int InsertBarCode(BarCode bc, int UserID, string latitude, string longitude, string DeviceID, string DeviceType, string Description) { int LogID = 0; List <SqlParameter> prams = new List <SqlParameter>(); try { using (DbManager db = DbManager.GetDbManager()) { prams.Add(db.MakeInParam("@intBarcodeID", SqlDbType.Int, 0, bc.BarCodeID)); prams.Add(db.MakeInParam("@intUserID", SqlDbType.Int, 0, UserID)); prams.Add(db.MakeInParam("@dcmlatitude", SqlDbType.VarChar, 50, latitude)); prams.Add(db.MakeInParam("@dcmlongitude", SqlDbType.VarChar, 50, longitude)); prams.Add(db.MakeInParam("@vchDeviceID", SqlDbType.VarChar, 50, DeviceID)); prams.Add(db.MakeInParam("@vchDeviceType", SqlDbType.VarChar, 50, DeviceType)); prams.Add(db.MakeInParam("@vchDescription", SqlDbType.VarChar, 200, Description)); LogID = db.RunProc("Up_InsertBarCodeLog", prams.ToArray()); } } catch (Exception ex) { LogID = 0; new SqlLog().InsertSqlLog(0, "BarCode.InsertBarCode", ex); } return(LogID); }
public static int Insert(BarCode bar) { int LogID = 0; List <SqlParameter> prams = new List <SqlParameter>(); try { using (DbManager db = DbManager.GetDbManager()) { prams.Add(db.MakeInParam("@vchSerialNumber", SqlDbType.NVarChar, 12, bar.BarCodeNumber)); prams.Add(db.MakeInParam("@dtmDateCreated", SqlDbType.DateTime, 8, Convert.ToDateTime(bar.DateCreated))); prams.Add(db.MakeInParam("@intOrgId", SqlDbType.Int, 4, bar.OrganizationID)); prams.Add(db.MakeInParam("@Image", SqlDbType.VarBinary, -1, bar.Image)); LogID = db.RunProc("up_InsertBarcode", prams.ToArray()); } } catch (Exception ex) { LogID = 0; new SqlLog().InsertSqlLog(0, "BarCode.Insert", ex); } return(LogID); }
public static int Insert(BarCode bar) { int LogID = 0; List<SqlParameter> prams = new List<SqlParameter>(); try { using (DbManager db = DbManager.GetDbManager()) { prams.Add(db.MakeInParam("@vchSerialNumber", SqlDbType.NVarChar, 12, bar.BarCodeNumber)); prams.Add(db.MakeInParam("@dtmDateCreated", SqlDbType.DateTime, 8, Convert.ToDateTime(bar.DateCreated))); prams.Add(db.MakeInParam("@intOrgId", SqlDbType.Int, 4, bar.OrganizationID)); prams.Add(db.MakeInParam("@Image", SqlDbType.VarBinary, -1, bar.Image)); LogID = db.RunProc("up_InsertBarcode", prams.ToArray()); } } catch (Exception ex) { LogID = 0; new SqlLog().InsertSqlLog(0, "BarCode.Insert", ex); } return LogID; }
public static int InsertBarCode(BarCode bc, int UserID, string latitude, string longitude, string DeviceID, string DeviceType, string Description) { int LogID = 0; List<SqlParameter> prams = new List<SqlParameter>(); try { using (DbManager db = DbManager.GetDbManager()) { prams.Add(db.MakeInParam("@intBarcodeID", SqlDbType.Int, 0, bc.BarCodeID)); prams.Add(db.MakeInParam("@intUserID", SqlDbType.Int, 0, UserID)); prams.Add(db.MakeInParam("@dcmlatitude", SqlDbType.VarChar, 50, latitude)); prams.Add(db.MakeInParam("@dcmlongitude", SqlDbType.VarChar, 50, longitude)); prams.Add(db.MakeInParam("@vchDeviceID", SqlDbType.VarChar, 50, DeviceID)); prams.Add(db.MakeInParam("@vchDeviceType", SqlDbType.VarChar, 50, DeviceType)); prams.Add(db.MakeInParam("@vchDescription", SqlDbType.VarChar, 200, Description)); LogID = db.RunProc("Up_InsertBarCodeLog", prams.ToArray()); } } catch (Exception ex) { LogID = 0; new SqlLog().InsertSqlLog(0, "BarCode.InsertBarCode", ex); } return LogID; }