internal int updateJointWorkingShopInDetails(JointWorkShopInAndOutBO jointWorkShopInAndOutBO) { try { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(jointWorkShopInAndOutBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "uspUpdateJointWorkingShopInAndOut"; sqlHelper.AddParameter(command, "@Mode", "1", ParameterDirection.Input); sqlHelper.AddParameter(command, "@UserId", jointWorkShopInAndOutBO.UserId, ParameterDirection.Input); if (!String.IsNullOrEmpty(jointWorkShopInAndOutBO.ShopInId) && String.Compare(jointWorkShopInAndOutBO.ShopInId, "0") != 0) { sqlHelper.AddParameter(command, "@ShopInId", jointWorkShopInAndOutBO.ShopInId, ParameterDirection.Input); } if (!String.IsNullOrEmpty(jointWorkShopInAndOutBO.ShopInTime) && String.Compare(jointWorkShopInAndOutBO.ShopInTime, "1/1/1900 12:00:00 AM") != 0) { sqlHelper.AddParameter(command, "@ShopInTime", jointWorkShopInAndOutBO.ShopInTime, ParameterDirection.Input); } if (!String.IsNullOrEmpty(jointWorkShopInAndOutBO.ShopOutId) && String.Compare(jointWorkShopInAndOutBO.ShopOutId, "0") != 0) { sqlHelper.AddParameter(command, "@ShopOutId", jointWorkShopInAndOutBO.ShopOutId, ParameterDirection.Input); } if (!String.IsNullOrEmpty(jointWorkShopInAndOutBO.ShopOutTime) && String.Compare(jointWorkShopInAndOutBO.ShopOutTime, "1/1/1900 12:00:00 AM") != 0) { sqlHelper.AddParameter(command, "@ShopOutTime", jointWorkShopInAndOutBO.ShopOutTime, ParameterDirection.Input); } if (!String.IsNullOrEmpty(jointWorkShopInAndOutBO.JointWorkUserId)) { sqlHelper.AddParameter(command, "@JointWorkingUserId", jointWorkShopInAndOutBO.JointWorkUserId, ParameterDirection.Input); } if (!String.IsNullOrEmpty(jointWorkShopInAndOutBO.BeatPlanDeviationReasionId) && String.Compare(jointWorkShopInAndOutBO.BeatPlanDeviationReasionId, "0") != 0) { sqlHelper.AddParameter(command, "@BeatPlanDeviationReasonId", jointWorkShopInAndOutBO.BeatPlanDeviationReasionId, ParameterDirection.Input); } sqlHelper.AddParameter(command, "@MobileTransactionDate", jointWorkShopInAndOutBO.MobileTransactionDate, ParameterDirection.Input); sqlHelper.AddParameter(command, "@MobileRefNo", jointWorkShopInAndOutBO.MobileReferenceNo, ParameterDirection.Input); if (!String.IsNullOrEmpty(jointWorkShopInAndOutBO.BeatPlanId)) { sqlHelper.AddParameter(command, "@BeatPlanId", jointWorkShopInAndOutBO.BeatPlanId, ParameterDirection.Input); } if (!String.IsNullOrEmpty(jointWorkShopInAndOutBO.MobileSyncDate)) { sqlHelper.AddParameter(command, "@MobileSyncDate", jointWorkShopInAndOutBO.MobileSyncDate, ParameterDirection.Input); } sqlHelper.AddParameter(command, "@ShopName", jointWorkShopInAndOutBO.ShopName, ParameterDirection.Input); return(Convert.ToInt32(sqlHelper.ExecuteNonQuery(command))); } catch (Exception ex) { throw ex; } }
internal int updateJointWorkingShopInDetailsOffline(JointWorkShopInAndOutBO jointWorkShopInAndOutBO) { try { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(jointWorkShopInAndOutBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "uspUpdateJointWorkingShopInAndOut"; sqlHelper.AddParameter(command, "@Mode", "3", ParameterDirection.Input); sqlHelper.AddParameter(command, "@UserId", jointWorkShopInAndOutBO.UserId, ParameterDirection.Input); if (!String.IsNullOrEmpty(jointWorkShopInAndOutBO.BeatPlanActivityConfigsId) && String.Compare(jointWorkShopInAndOutBO.BeatPlanActivityConfigsId, "0") != 0) { sqlHelper.AddParameter(command, "@BeatPlanActivityConfigsId", jointWorkShopInAndOutBO.BeatPlanActivityConfigsId, ParameterDirection.Input); } sqlHelper.AddParameter(command, "@SurveyGroupId", jointWorkShopInAndOutBO.SurveyGroupId, ParameterDirection.Input); if (!String.IsNullOrEmpty(jointWorkShopInAndOutBO.BeatPlanId) && String.Compare(jointWorkShopInAndOutBO.BeatPlanId, "0") != 0) { sqlHelper.AddParameter(command, "@BeatPlanId", jointWorkShopInAndOutBO.BeatPlanId, ParameterDirection.Input); } if (!String.IsNullOrEmpty(jointWorkShopInAndOutBO.ShopId) && String.Compare(jointWorkShopInAndOutBO.ShopId, "0") != 0) { sqlHelper.AddParameter(command, "@ShopId", jointWorkShopInAndOutBO.ShopId, ParameterDirection.Input); } sqlHelper.AddParameter(command, "@MobileRefNo", jointWorkShopInAndOutBO.MobileReferenceNo, ParameterDirection.Input); sqlHelper.AddParameter(command, "@ShopName", jointWorkShopInAndOutBO.ShopName, ParameterDirection.Input); sqlHelper.AddParameter(command, "@MobileSyncDate", jointWorkShopInAndOutBO.MobileSyncDate, ParameterDirection.Input); sqlHelper.AddParameter(command, "@MobileTransactionDate", jointWorkShopInAndOutBO.MobileTransactionDate, ParameterDirection.Input); if (!String.IsNullOrEmpty(jointWorkShopInAndOutBO.QuestionId) && String.Compare(jointWorkShopInAndOutBO.QuestionId, "0") != 0) { sqlHelper.AddParameter(command, "@QuestionId", jointWorkShopInAndOutBO.QuestionId, ParameterDirection.Input); } if (!String.IsNullOrEmpty(jointWorkShopInAndOutBO.AnswerId) && String.Compare(jointWorkShopInAndOutBO.AnswerId, "0") != 0) { sqlHelper.AddParameter(command, "@AnswerId", jointWorkShopInAndOutBO.AnswerId, ParameterDirection.Input); } sqlHelper.AddParameter(command, "@latitude", jointWorkShopInAndOutBO.Latitude, ParameterDirection.Input); sqlHelper.AddParameter(command, "@longitude", jointWorkShopInAndOutBO.Longitude, ParameterDirection.Input); sqlHelper.AddParameter(command, "@gpsSource", jointWorkShopInAndOutBO.GpsSource, ParameterDirection.Input); sqlHelper.AddParameter(command, "@Remarks", jointWorkShopInAndOutBO.Remarks, ParameterDirection.Input); if (!String.IsNullOrEmpty(jointWorkShopInAndOutBO.JointWorkUserId)) { sqlHelper.AddParameter(command, "@JointWorkingUserId", jointWorkShopInAndOutBO.JointWorkUserId, ParameterDirection.Input); } return(Convert.ToInt32(sqlHelper.ExecuteNonQuery(command))); } catch (Exception ex) { throw ex; } }