public object Load(string file)
{
var persistent = PersistentHelper.Load(file, base.GetType()) as BundlePersistent;
if (persistent != null)
{
InstalledBundleLocation = persistent.InstalledBundleLocation;
UnInstalledBundleLocation = persistent.UnInstalledBundleLocation;
}
return(persistent);
}
//Allows this elements and it's children to remain between scene trainsitions.
private void Awake()
{
if (persistentElement == null)
{
DontDestroyOnLoad(gameObject);
persistentElement = this;
}
else if (persistentElement != this)
{
Destroy(gameObject);
}
}
// [EnableCors(origins: "http://localhost:50158", headers: "*", methods: "*")]
public string CreateOrder([FromBody] OrderDetails orderDetails)
{
if (orderDetails != null)
{
//var jsonString = json.ToString();
//OrderDetails orderDetails = JsonConvert.DeserializeObject<OrderDetails>(jsonString);
if (string.IsNullOrEmpty(orderDetails.destination) || string.IsNullOrEmpty(orderDetails.challanNumber))
{
throw new ArgumentException("Destination or challan number cannot be null/empty");
}
if (orderDetails.requestTime == null)
{
throw new ArgumentException("Request time cannot be null");
}
if (orderDetails.noOfItems <= 0)
{
throw new ArgumentException("Number of items not specified");
}
//if order exists with the same retailer name and challan number then donot create order
OrderDetails order = new PersistentHelper().GetSpecificOrder(orderDetails.destination, orderDetails.challanNumber);
if (order == null)
{
return(new PersistentHelper().CreateOrder(orderDetails));
}
else
{
return("Order already exist");
}
}
else
{
throw new Exception("Input is null.");
}
}
public void Save(string file)
{
PersistentHelper.Save(file, this);
}
public string SignUp([FromBody] LoginInfo loginInfo)
{
if (loginInfo != null)
{
if (!string.IsNullOrEmpty(loginInfo.LoginId) && !string.IsNullOrEmpty(loginInfo.LoginType))
{
bool loginFormat = loginInfo.LoginId.GetUntilOrEmpty().Equals(loginInfo.LoginType.Substring(0, 2),
StringComparison.InvariantCultureIgnoreCase);
if (!loginFormat)
{
throw new Exception("Login id is not in proper format.");
}
}
else
{
throw new ArgumentException("Login id or Login type is null.");
}
String query = String.Empty;
String returnStr = String.Empty;
bool exist = false;
List <LoginInfo> users = null;
List <MySqlParameter> prm = new List <MySqlParameter>();
switch (loginInfo.LoginType.ToLower())
{
case "distributor":
case "wholesaler":
case "retailer":
users = new PersistentHelper().GetUser("email_id", loginInfo.EMailId);
if (users.Count > 0)
{
exist = true;
}
else
{
query = "INSERT INTO `mlo`.`users`(login_id,password,login_type,first_name,surname,firm_name,address," +
"gst_no,mobile_no,email_id,gender,profile_pic,dob,access_token,shop_no)" +
"VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);Select LAST_INSERT_ID() as id;";
prm = new List <MySqlParameter>()
{
new MySqlParameter("@login_id", MySqlDbType.VarChar)
{
Value = loginInfo.LoginId
},
new MySqlParameter("@password", MySqlDbType.VarChar)
{
Value = loginInfo.Password
},
new MySqlParameter("@login_type", MySqlDbType.VarChar)
{
Value = loginInfo.LoginType
},
new MySqlParameter("@first_name", MySqlDbType.VarChar)
{
Value = loginInfo.Name
},
new MySqlParameter("@surname", MySqlDbType.VarChar)
{
Value = loginInfo.last_name
},
new MySqlParameter("@firm_name", MySqlDbType.VarChar)
{
Value = loginInfo.firm_name
},
new MySqlParameter("@address", MySqlDbType.VarChar)
{
Value = loginInfo.FirmAddress
},
new MySqlParameter("@gst_no", MySqlDbType.VarChar)
{
Value = loginInfo.GSTNo
},
new MySqlParameter("@mobile_no", MySqlDbType.VarChar)
{
Value = loginInfo.MobileNumber
},
new MySqlParameter("@email_id", MySqlDbType.VarChar)
{
Value = loginInfo.EMailId
},
new MySqlParameter("@gender", MySqlDbType.VarChar)
{
Value = loginInfo.Gender
},
new MySqlParameter("@profile_pic", MySqlDbType.VarChar)
{
Value = loginInfo.Url
},
new MySqlParameter("@dob", MySqlDbType.DateTime)
{
Value = new DateTime()
},
new MySqlParameter("@access_token", MySqlDbType.VarChar)
{
Value = loginInfo.AccessToken
},
new MySqlParameter("@shop_no", MySqlDbType.Int16)
{
Value = loginInfo.ShopNo
}
};
}
break;
case "collector":
users = new PersistentHelper().GetCollector("email_id", loginInfo.EMailId);
if (users.Count > 0)
{
exist = true;
}
else
{
query = "INSERT INTO `mlo`.`collector`(login_id, password, first_name, surname, address, mobile_no, " +
"email_id, gender, profile_pic, dob, access_token, govt_id, govt_id_no)" +
"VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?);" +
"Select LAST_INSERT_ID() as id;";
prm = new List <MySqlParameter>()
{
new MySqlParameter("@login_id", MySqlDbType.VarChar)
{
Value = loginInfo.LoginId
},
new MySqlParameter("@password", MySqlDbType.VarChar)
{
Value = loginInfo.Password
},
new MySqlParameter("@first_name", MySqlDbType.VarChar)
{
Value = loginInfo.Name
},
new MySqlParameter("@surname", MySqlDbType.VarChar)
{
Value = loginInfo.last_name
},
new MySqlParameter("@address", MySqlDbType.VarChar)
{
Value = loginInfo.FirmAddress
},
new MySqlParameter("@mobile_no", MySqlDbType.VarChar)
{
Value = loginInfo.MobileNumber
},
new MySqlParameter("@email_id", MySqlDbType.VarChar)
{
Value = loginInfo.EMailId
},
new MySqlParameter("@gender", MySqlDbType.VarChar)
{
Value = loginInfo.Gender
},
new MySqlParameter("@profile_pic", MySqlDbType.VarChar)
{
Value = loginInfo.Url
},
new MySqlParameter("@dob", MySqlDbType.DateTime)
{
Value = new DateTime()
},
new MySqlParameter("@access_token", MySqlDbType.VarChar)
{
Value = loginInfo.AccessToken
},
new MySqlParameter("@govt_id", MySqlDbType.VarChar)
{
Value = loginInfo.GovtId
},
new MySqlParameter("@govt_id_no", MySqlDbType.VarChar)
{
Value = loginInfo.GovtIdNo
}
};
}
break;
case "loader":
users = new PersistentHelper().GetLoader("email_id", loginInfo.EMailId);
if (users.Count > 0)
{
exist = true;
}
else
{
query = "INSERT INTO `mlo`.`loader`(login_id, password, first_name, surname, address, mobile_no, " +
"email_id, gender, profile_pic, dob, access_token, govt_id, govt_id_no )" +
"VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?);" +
"Select LAST_INSERT_ID() as id;";
prm = new List <MySqlParameter>()
{
new MySqlParameter("@login_id", MySqlDbType.VarChar)
{
Value = loginInfo.LoginId
},
new MySqlParameter("@password", MySqlDbType.VarChar)
{
Value = loginInfo.Password
},
new MySqlParameter("@first_name", MySqlDbType.VarChar)
{
Value = loginInfo.Name
},
new MySqlParameter("@surname", MySqlDbType.VarChar)
{
Value = loginInfo.last_name
},
new MySqlParameter("@address", MySqlDbType.VarChar)
{
Value = loginInfo.FirmAddress
},
new MySqlParameter("@mobile_no", MySqlDbType.VarChar)
{
Value = loginInfo.MobileNumber
},
new MySqlParameter("@email_id", MySqlDbType.VarChar)
{
Value = loginInfo.EMailId
},
new MySqlParameter("@gender", MySqlDbType.VarChar)
{
Value = loginInfo.Gender
},
new MySqlParameter("@profile_pic", MySqlDbType.VarChar)
{
Value = loginInfo.Url
},
new MySqlParameter("@dob", MySqlDbType.DateTime)
{
Value = new DateTime()
},
new MySqlParameter("@access_token", MySqlDbType.VarChar)
{
Value = loginInfo.AccessToken
},
new MySqlParameter("@govt_id", MySqlDbType.VarChar)
{
Value = loginInfo.GovtId
},
new MySqlParameter("@govt_id_no", MySqlDbType.VarChar)
{
Value = loginInfo.GovtIdNo
}
};
}
break;
case "driver":
List <DriverDetails> drivers = new PersistentHelper().GetDriver("email_id", loginInfo.EMailId);
if (drivers.Count > 0)
{
exist = true;
}
else
{
query = "INSERT INTO `mlo`.`driver`(login_id, password, first_name, surname, address, mobile_no, " +
"email_id, gender, profile_pic, dob, access_token, govt_id, govt_id_no )" +
"VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?);" +
"Select LAST_INSERT_ID() as id;";
prm = new List <MySqlParameter>()
{
new MySqlParameter("@login_id", MySqlDbType.VarChar)
{
Value = loginInfo.LoginId
},
new MySqlParameter("@password", MySqlDbType.VarChar)
{
Value = loginInfo.Password
},
new MySqlParameter("@first_name", MySqlDbType.VarChar)
{
Value = loginInfo.Name
},
new MySqlParameter("@surname", MySqlDbType.VarChar)
{
Value = loginInfo.last_name
},
new MySqlParameter("@address", MySqlDbType.VarChar)
{
Value = loginInfo.FirmAddress
},
new MySqlParameter("@mobile_no", MySqlDbType.VarChar)
{
Value = loginInfo.MobileNumber
},
new MySqlParameter("@email_id", MySqlDbType.VarChar)
{
Value = loginInfo.EMailId
},
new MySqlParameter("@gender", MySqlDbType.VarChar)
{
Value = loginInfo.Gender
},
new MySqlParameter("@profile_pic", MySqlDbType.VarChar)
{
Value = loginInfo.Url
},
new MySqlParameter("@dob", MySqlDbType.DateTime)
{
Value = new DateTime()
},
new MySqlParameter("@access_token", MySqlDbType.VarChar)
{
Value = loginInfo.AccessToken
},
new MySqlParameter("@govt_id", MySqlDbType.VarChar)
{
Value = loginInfo.GovtId
},
new MySqlParameter("@govt_id_no", MySqlDbType.VarChar)
{
Value = loginInfo.GovtIdNo
}
};
}
break;
default:
throw new Exception("Login type has not been specified.");
}
if (!exist)
{
returnStr = new PersistentHelper().SignUp(loginInfo, query, prm);
}
else
{
returnStr = "Already Signed up with this email id.";
}
return(returnStr);
}
else
{
throw new ArgumentException("Input is null!");
}
}
